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!
The Conceptual Level or Global level
The conceptual level presents a logical view of the complete database as a unified whole. It permits the user to bring all the data in the database mutually and see it in a constant manner. However, there is only one conceptual schema per database. The primary stage in the design of a database is to describe the conceptual view, and a DBMS gives a data definition language for this purpose. It tells all the records and relationships included in the database.
The data definition language used to make the conceptual level must not specify any physical storage considerations that should be handled by the physical level. It does not give any storage or access details, but tells the information content only.
Explain Record Based Logical Models? Record-Based logical Models: Also define data at the conceptual and view levels. Unlike object-oriented models, are used to state overall
Explain Relational model and their use in DBMS? Relational Model - The relational model was first introduced through E.F. Codd of the IBM Research in the year of 1970. The mode
Let us first look into some of the important features of ER model. Entity relationship model is a high-level conceptual data model. It permits us to define the data invo
What is the full form of DDL? DDL is stand for Data Definition Language.
What are the Objectives of object design After going through this unit, you could be able to: explain steps of object design; discuss algorithms that reduce costs;
what is Lossless-join decomposition
What is a checkpoint? List the operations to be performed by the system when a checkpoint is to be taken. What does the recovery system do if there is a crash? There is large n
E-R model uses this symbol to represent weak entity set ? A Doubly outlined rectangle symbol is used to represent weak entity set.
What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.
Association as a cache This association must be updated when any new element is added to it, but testing for overlap using association is more efficient. Figure:
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