Describe the College Management system in three layer architecture?

The three-schema architecture divides the database into three-level used to create a separation between the physical database and the user application. In simple terms, this architecture hides the details of physical storage from the user.

The database administrator (DBA) responsible is to change the structure of database storage without affecting the user’s view. It deals with the data, the relationship between them and the different access methods implemented on the database. The logical design of a database is called a schema.

This architecture contains three layers of database management system (DBMS) −

External level
Conceptual level
Internal level

The three layers of the DBMS are pictorially represented below −

External View

View 1 − Library User

Roll number, Name, Address, Book Number, Date of Issue,
Date of Return

View 2 − Account office

Roll Number, Name, Fees

Conceptual View

Conceptual View for view 1 and view 2 are −

Field Name	Data type(size)
Roll Number	Number(20)
Name	Char(20)
Address	varchar(20)
Book number	Number(20)
Date of Issue	varchar(20)
Date of return	varchar(20)

Internal View

Internal View on hard Disk

Stored Item	Length
Roll Number	Type=byte(20), offset(starting address) =20
Name	Type=byte(20), offset=20
Address	Type=byte(20), offset=20

Bhanu Priya

Published on 03-Jul-2021 09:55:11

Previous Page Print Page