Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Define the concept of aggregation. Give two examples where this concept is useful.
Ans: Aggregation transforms a relationship among the objects into a higher-level object. A new data type known as aggregate is developed which, under specific criteria of "well-definedness," defines aggregation abstractions. Relational databases illustrated as collections of aggregates are structured like a hierarchy of n-ary relations. To keep well-definedness, update operations on such type of databases must keep two invariants. Well-defined relations are different from relations in third normal form. It is displayed that these notions are complementary and both are significant in database design. A top-down method for database design is described that separates decisions concerning aggregate structure from decisions concerning key identification. It is suggested that aggregate types, and other sorts which support real-world abstractions with no introducing Key identification.
Consider the subsequent relations for a database which keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, start_year, Dept_no) TRIP (SSN, Fr
Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)
What are stored-procedures? And what are the advantages of using them? Stored procedures are database objects that perform a user defined operation. A stored procedure can have
describe objectivde of file organisation
What is a Database? To know what database is, we have to start from data, which is the basic building block of any DBMS. Data: Facts, figures, statistics etc. having no pa
Explain the ISA relationship Answer: ISA relationship - ISA notation is employed in generalization/ specialization to depict relationship among lower and higer level entity s
What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet
Describe the candidate key functions ? Candidate Key and Alternate Key: In some instances, an entity will have more than one attribute which can serve as a primary key. Any key
Explain the Object-oriented decomposition Object-oriented decomposition targets at identifying individual sovereign objects that encapsulate both a state and certain behavio
Authorisation Authorisation is the culmination of the administrative policies of the organisation. As the name shows, authorisation is a set of rules that can be used to verif
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd