Q1Database Management System
Question
4 marks
Explain the three-level architecture of DBMS.
Answer
External, Conceptual, and Internal levels.
The three-level architecture (ANSI/SPARC) separates the physical database from the user's view:
- External Level (View Level): Describes part of the database relevant to a particular user.
- Conceptual Level (Logical Level): Describes what data is stored and the relationships among data.
- Internal Level (Physical Level): Describes how data is physically stored on the disk.
