Explain different levels of data abstraction in a DBMS.

1.	Explain different levels of data abstraction in a DBMS.
Answer» The PROCESS of hiding irrelevant DETAILS from users is known as DATA abstraction. Data abstraction can be divided into 3 LEVELS: Physical Level: it is the lowest level and is managed by DBMS. This level consists of data storage descriptions and the details of this level are typically hidden from system admins, developers, and users. Conceptual or Logical level: it is the level on which developers and system admins work and it determines what data is stored in the database and what is the relationship between the data points. External or View level: it is the level that DESCRIBES only part of the database and hides the details of the table schema and its physical storage from the users. The result of a query is an example of View level data abstraction. A view is a virtual table created by selecting fields from one or more tables present in the database.

Answer»

The PROCESS of hiding irrelevant DETAILS from users is known as DATA abstraction. Data abstraction can be divided into 3 LEVELS:

Physical Level: it is the lowest level and is managed by DBMS. This level consists of data storage descriptions and the details of this level are typically hidden from system admins, developers, and users.
Conceptual or Logical level: it is the level on which developers and system admins work and it determines what data is stored in the database and what is the relationship between the data points.
External or View level: it is the level that DESCRIBES only part of the database and hides the details of the table schema and its physical storage from the users. The result of a query is an example of View level data abstraction. A view is a virtual table created by selecting fields from one or more tables present in the database.

Discussion