Discuss the three levels of abstraction in DBMS.

Database systems comprise of complex data structures. Thus, to make the system efficient for retrieval of data and reduce the complexity of the users, developers use the method of Data Abstraction.

There are mainly three levels of data abstraction:

Internal Level: Actual PHYSICAL storage structure and access paths.

Conceptual or Logical Level: Structure and constraints for the entire database

External or View level: Describes various user views

Internal Level/Schema

The internal schema defines the physical storage structure of the database. The internal schema is a very low-level representation of the entire database. It contains multiple occurrences of multiple types of internal record. In the ANSI term, it is ________ ____ ___ ______ _______ ______ _______.
____ _________ ___ ________ _____.
_______ __________ _________ _________ ________.
_________ _______ ______ ______ _________ ____ _____ _________.
_______ ___ _____ ____ ______.
__________ ____ _____ _____ _________ _____ ____ ______.
_______ __________ _____ __________ ________ _________ ________ _____.
____ __________ ___ __________ ______ _________ __________ ____ _______ _____ __________.
_______ _________ _________ ________ _______ ___ _____ __________ _______ ___ ____.
_________ ______ ___ ____ _____ __________.
___ __________ ___ _________ ________.
_________ ___ ______ __________ _________ ________ ____ ____ ___ ________ ___ ______.
____ ____ ___ ___ _____ ______ ______ __________ _________ ___ _______.
_______ _________ _____ _________ _________ ___ ________.
_________ ____ __________ ___ _______ _____ _____ _______ _________ ______ __________ _____.
___ _____ __________ __________ ________ ___ ______ ___.
___ _______ ______ _____ _____ _________ _____ _______.
_______ _____ ________ _________ _____ ______ ____ __________ ____ _______ ________.
______ ___ _______ _________ _____ _____ ______.
_______ __________ _________ ____ __________ ___ ________ ______ ____ ________.
_________ _______ ___ ______ __________ ___ _______ _________ _____ _____ _____.
____ __________ ____ ____ _____.
_______ ______ _________ ___ _________ ______.
________ _____ ____ ____ ______ ________ __________ ______ _________ ___ _____ ___.
_______ ___ _______ ___ _________.
_________ _____ ___ ________ _______ _________ ___ ______.
_______ ___ ____ ________ _________ ______ _________ _______ ________ _______ __________.
_______ _______ ______ ______ ___ _______ __________.
_______ _____ ________ ________ ________ ________.
______ _____ ________ ______ ________ ____ ________ _____ ____ ___ ______ ______.
_______ _____ __________ __________ ___ _______ ______ _____ _________ ____.
_____ ____ ________ ________ ____ ___ _______ __________ ______.
_______ ___ _______ __________ ____ ________ _________ ___ ________ __________ ________ __________.
_____ ___ ________ ______ _____.
_______ ________ _________ ______ ______ _____.
______ ____ ________ ____ ____ ______.
_________ _________ ________ ___ ____ ______ ______.
______ ___ _____ _________ _________ _______.
____ ____ ____ ______ ______ _____.
_________ ____ _______ ___ _____ ______ _______ _________ __________.
__________ __________ ______ ____ _________ ______ ___ _________ _____ ___ _________.
__________ ____ ____ _______ _________ ________ _______ ______ _______ _________.
_______ ____ __________ _____ ______.
_________ ____ __________ _______ ______ ___ _____ _______ ____ ______.
___ _______ _____ ____ _________ _________.
__________ _______ _____ ____ ____ _______ _________ ________.
_____ _____ ______ ______ __________ _____.
____ ________ ________ _____ ______ ______ ________ _____ ___ ______ _______ ________.
______ ____ __________ _____ ______ _________ __________ ___ _______ ______ ____.
______ ________ ________ ________ _________ ________ _________ ______ ________.
___ _____ ______ ___ ______ ______.
____ ________ __________ _______ _________ _________ ________ __________ ___ _________ ______ _________.
_________ __________ _____ ____ ________ ____ _____ __________ _________ _________ ____.
______ _______ _____ ______ ______ _____.
____ ___ _________ _________ _______ __________ _____ ____.
______ __________ ____ _______ __________ _________ ___ _________ ________.
___ ____ _____ ________ __________ ___.
______ ______ _____ _________ ________ _________ ________ ____ _________ _________.
________ ___ _________ ____ __________ __________ ________ __________ ____ ______ _______.
___ ____ _____ __________ _____ ____ _________ _____ _______.
___ ____ ____ _________ _______.
__________ ________ ____ _________ ________ ________ ________ _____ ______ _____ ___ _____.
______ ________ ______ _______ ________ _______ ________ ____.
_________ _______ ______ __________ ____ _____ __________ ________ ___ _____ _________ ____.
__________ _____ _________ _______.
Get Full Answer on WhatsApp