Final answer:
The 3-schema DB architecture includes the external schema for user views the conceptual schema as the organizational view of all data and the internal schema detailing physical storage.
Step-by-step explanation:
The 3-schema DB architecture is a strategy to design database systems that aims to separate the user applications from the physical database. This architecture consists of three levels:
- External schema: Also known as the view level, it is concerned with the way individual users view the data. In essence each external schema provides a personalized view of the database tailored to the needs of a particular category of users.
- Conceptual schema: This is the community or organizational view. It represents the entire content of the database as understood by the database users. It is abstract in nature and is concerned with defining the various entities, relationships and rules in the database without considering how they will be realized on the physical storage level.
- Internal schema: Also termed as the physical level it describes how the data is stored in the database including the physical storage structures and access paths. It optimizes performance while ensuring that the data stored is secured and reliably maintained.
This conceptual framework facilitates system changes on one level without requiring changes on other levels making it a dynamic and efficient approach to database management. Each level in the three-schema architecture is designed to support independence and flexibility.