Three Level Architecture of Database

In this blog we are discussing about the Three Level Architecture of Database . These are Physical level , Conceptual level and External level .

Let’s Go to Brief Explanation : -

Three Level Architecture

1. External Level :- This is the top level of Three Level Architecture of Database and closer to the user . External Level only shows relevant data to the user fetching from internally with the help of Physical level and Conceptual level . This level is also known as “View Level” .
2. Conceptual level :- This is the middle of Three Level Architecture of Database . This level is also known as “Logical Level” , because all the logical work is done in this level . It also design the whole database and the defines the relationship between the tables in the database .
3. Physical level :- This is lowest level in Architecture . It is also known as “internal level” . It actually describes that how data is stored in the database . This level also responsible for allocating the space to data . The data is stored in the external hard drives in the form of bits .