FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WHAT IS DATABASE MANAGEMENT

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Basis for the identification and high-level description of the main data objects
A
Logical design
B
Conceptual schema
C
Logical independence
D
None of the above
Explanation: 

Detailed explanation-1: -Also known as a conceptual schema, it is the basis for identification and high – level description of the main data objects (avoiding any database model-specific details). The most widely used conceptual model is the ER model.

Detailed explanation-2: -High-level conceptual data models provide concepts for presenting data in ways that are close to the way people perceive data. A typical example is the entity relationship model, which uses main concepts like entities, attributes and relationships.

Detailed explanation-3: -A conceptual schema or conceptual data model is a map of concepts and their relationships used for databases. This describes the semantics of an organization and represents a series of assertions about its nature.

Detailed explanation-4: -A framework for managing access to data that involves three layers or schemas: the external or programming view, the conceptual or data administration view, and the internal or database administration view.

Detailed explanation-5: -Conceptual Level It is also known as the logical level. It describes how the database appears to the users conceptually and the relationships between various data tables. The conceptual level does not care for how the data in the database is actually stored.

There is 1 question to complete.