Biography, Science, Technology, Health, History Blogs

Three schema Architecture DBMS Three schema Architecture Internal Level  Conceptual Level  External Level  Three schema Architecture  Three schema architecture is also called ANSI / SPARC architecture or three-level architecture. This framework is used to describe the structure of a specific database system. The three schema architecture is also used to separate user applications and physical databases. There are three levels in the three schema architecture. It breaks the database into three different categories. The three-schema architecture is as follows: In the above diagram: It shows the DBMS architecture. Mapping is used to convert request and response between different database levels of the architecture. Mapping is not good for small DBMS as it takes more time. External / conceptual mapping, it is necessary to convert the link from the external level to the conceptual schema. Conceptual / internal mapping converts DBMS requests from conceptual to internal lev...