Describe the College Management system in three layer architecture?

DBMSDatabaseBig Data Analytics

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
raja
Published on 03-Jul-2021 09:55:11
Advertisements