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.
It defines that the tuple in one relation that refers to another relation must refer to an existing tuple in that relation. This constraint is states on two relations (not essentia
Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs
What are the Constituents of File? Also elaborates all the possible file operations? A file is organised logically as sequence of record. These records are mapped onto disk blo
Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.
What is an ERD?
What is disadvantage of multiple inheritances? There is potential ambiguity if the similar variable or method can be inherited from more than one superclass.eg: student class m
Consider the E/R schema with weak entity sets shown below. Come up with the SQL CREATE TABLE statements (with appropriate primary key, unique and foreign key constraints). Include
Explain CNT in the respects of QBE ? CNT: It is one of the aggregation commands given in QBE. It is used to identify number of tuples
List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation
how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd