The Three-Schema Architecture
Explore the three-schema architecture used in database design to separate user applications from physical storage. Understand the external, conceptual, and internal schemas, and how this approach allows customized user views, simplifies access, and supports data independence for efficient database management.
The three-schema architecture
The goal of the three-schema architecture is to separate the user applications from the physical database.
In this architecture, schemas can be defined at the following three levels:
1. External schema
An external schema describes the part of the database that a specific user is interested in. It hides the unrelated details of the database from the user like the exact process of retrieving or storing data from the database. There is a different external view for ...