Levels of DBMS Architecture Diagram - DBMS

The database has 3 levels as shown in the diagram below 

    1. Physical/Internal 

    2. Conceptual 

    3. External 

Consider an Example of a University Database. At the different levels this is how the implementation will look like: 

Type of Schema	Implementation
External Schema	View 1: Course info(cid:int,cname:string) View 2: studeninfo(id:int.name:string)
Conceptual Shema	Students(id: int, name: string, login: string , age: integer) Courses(id: int, cname.string, credits:integer) Enrolled(id: int, grade:string)
Physical Schema	Relations stored as unordered files. Index on the first column of Students.

ALSO SEARCH:

"three level architecture of dbms"

"three-schema architecture"

"physical dbms architecture"

"internal level in dbms"

"external level in dbms"