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 called index-sequential files? The files that are ordered sequentially with a primary index on the search key are known as index-sequential files

folding method and mid square method using visual basic

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Determine the minimal set of functional dependencies for the following data. This table is part of the OHSU database of extracurricular activities and tracks the DMICE band's co

Locks: Serialisabilty is just a test whether a given interleaved schedule is ok or has a concurrency related trouble. Though, it does not make sure that the interleaved concurrent

What is deadlock? Neither of the transaction can ever proceed with its normal implementation. This situation is known as deadlock.

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".

Question: (a) What are decision support systems, and what role do they play in the business environment? (b) Data mining is a knowledge discovery process of automated extr

State the Design of Associations Before designing associations, it is essential to know the way they are used. For this, analysis of association traversals is required. It is

Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t