The conceptual level or global level in dbms, Database Management System

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.

 

Posted Date: 3/5/2013 5:00:34 AM | Location : United States







Related Discussions:- The conceptual level or global level in dbms, Assignment Help, Ask Question on The conceptual level or global level in dbms, Get Answer, Expert's Help, The conceptual level or global level in dbms Discussions

Write discussion on The conceptual level or global level in dbms
Your posts are moderated
Related Questions
What are the functions of an accumulator? The accumulator is the register associated with the ALU operations and sometimes I/O operations. It is an integral part of ALU. It hol

Enumerate or state the steps in creating a relevant database of a shop.

Data Definition Language It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL? Th

This assignment is worth 45% of your final grade for this module.  Marks will be awarded as follows: Prototypes (wireframe and web based prototype) You are expected

Briefly describe the different kinds of users of a DBMS.  Ans: Different sorts of DBMS users are: (a)  Software Engineers: These are the people accountable for developing ap

Explain the B + tree? B + tree is a type of tree which denotes sorted data in a way that permits for efficient insertion, retrieval and removal of records, each of which is

Single-Valued Dependencies A database is a collection of related information and it is therefore inevitable that some items of information in the database would depend on some

Explain weak and strong entity type ? Weak and Strong entity type: An entity set which does not have a primary key is referred to as a weak entity set. The existence of a wea

Discuss the types of integrity constraints in which must be checked for the update operations - Insert and Delete. Give examples. Insert operation can violet any of the subse

Define database management system? Database management system (DBMS) is a set of interrelated data and a combination of programs to access those data.