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!
Explain how the object classes are mapped to tables.
Each object class maps to one or more than one tables in the database. The objects in the class may be partitioned horizontally or/and vertically. For instance, if class has many instances of which, a few are often referenced. In this case, horizontal partitioning may improve efficiency by placing the frequently accessed objects in a table, and the remaining objects in another tables. Similarly, if a class has attributes with different access patterns, it may help to partition the objects vertically.
why are older data base model are being replaced by new data model
List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view. Ans: The two restrictions are: 1. If a view
Eliminate Redundant Data In the "Database Relation" above, the primary key is made up of the D-ID and the Emp-ID. The database-name relies only on the D-ID. The similar databas
milestone assignment
Probelm: (a) A distributed database (DDB) is a collection of multiple, logically interrelated databases which are physically distributed over a computer network" (i) Give a
design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.
What are the uses of the information in the Data dictionary? The following information is directly taken from the Data dictionary: Information on fields displayed with
What is an ER diagram? Why is it used in Database management system (DBMS)?
Draw entity relationship diagram for the following scenario. A university has many departments whereas each department belongs to that particular uni. That uni has also many bui
How are tables stored on Disk? We realise that every record of a table can have different amounts of data. This is due to in some records; some attribute values may be "zero".
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