FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WHAT IS DATABASE MANAGEMENT

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Operates at lowest level of abstraction
A
The Physical Model
B
The Network Model
C
The Conceptual Model
D
The External Model
Explanation: 

Detailed explanation-1: -The physical model operates at the lowest level of abstraction, describing the way data are saved on storage media such as disks or tapes. The storage structures used are dependent on the software (the DBMS and the operating system) and on the type of storage devices that the computer can handle.

Detailed explanation-2: -The internal schema is the lowest level of data abstraction. It helps you to keeps information about the actual representation of the entire database. Like the actual storage of the data on the disk in the form of records. The internal view tells us what data is stored in the database and how.

Detailed explanation-3: -Physical or Internal Level: The physical or internal layer is the lowest level of data abstraction in the database management system. It is the layer that defines how data is actually stored in the database. It defines methods to access the data in the database.

Detailed explanation-4: -There are three levels of abstraction : Physical Level: Defines how the data is actually stored employing various data structures. Logical level: Describes the relationship which exists among the stored data. View level: Provides a high level view of a section of data.

Detailed explanation-5: -Reason: Physical model operates at the lowest level of abstraction.

There is 1 question to complete.