- DBMS Tutorial
- DBMS - Home
- DBMS - Overview
- DBMS - Architecture
- DBMS - Data Models
- DBMS - Data Schemas
- DBMS - Data Independence
- Entity Relationship Model
- DBMS - ER Model Basic Concepts
- DBMS - ER Diagram Representation
- DBMS - Generalization, Aggregation
- Relational Model
- DBMS - Codd's Rules
- DBMS - Relational Data Model
- DBMS - Relational Algebra
- DBMS - ER to Relational Model
- DBMS- SQL Overview
- Relational Database Design
- DBMS - Database Normalization
- DBMS - Database Joins
- Storage and File Structure
- DBMS - Storage System
- DBMS - File Structure
- Indexing and Hashing
- DBMS - Indexing
- DBMS - Hashing
- Transaction And Concurrency
- DBMS - Transaction
- DBMS - Concurrency Control
- DBMS - Deadlock
- Backup and Recovery
- DBMS - Data Backup
- DBMS - Data Recovery
- DBMS Useful Resources
- DBMS - Quick Guide
- DBMS - Useful Resources
- DBMS - Discussion
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 |
- Related Articles
- Describe the Transport Layer in the Computer Network
- 3-Layer of IOT architecture?
- Monolithic System Architecture
- Computer System Architecture
- Explain the three level schema architecture in DBMS?
- File System Management
- 4 IoT Architecture Layer That You Should Know
- Loadable Modules Architecture of the Operating System
- Three levels of database architecture
- Three Level Architecture of Database
- Architecture of SAP HANA system
- Operating System Resource Management
- Database Management System (DBMS)
- Distributed Database Management System
- Centralized Database Management System
