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 key features of Oracle? Key features of Oracle are as follows: • Read Consistency • Concurrency • Locking Mechanisms • Quiesce Database • RAC • Portability

Describe disk manager and their work? Disk Manager: Responsible for fetching data regulated through file Manager from disk storage within Main memory and deciding what data to

What is difference between TRUNCATE and DELETE? - Truncate can't be rolled back whereas Delete can be. - Truncate keeps the lock on table whereas Delete keeps the lock on ea

Now that she understands more about the benefits of databases, the play-scheme manager would like to extend the play-scheme database to include data for schools and instructors as


Describe five main functions of a database administrator. Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Genera

What is data block? Data Block - In oracle the data blocks are referred to as tablespaces. A tablespace is an fields of disk consisting of one or more disk files. A tablespace

Consider the following six relation schemes and their corresponding sets of functional dependencies. In each case identify a. All the candidate keys b. The highest normal for

Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman

Define Query by Example QBE is a query language relies upon domain calculus and has two dimensional syntax. The queries are written in the horizontal and vertical dimensions of