Week 5-6: Database Schema Architecture
The 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 the user applications and physical database.
There are mainly three levels of data abstraction:
- Internal Level: Actual PHYSICAL storage structure and access paths.
- Conceptual or Logical Level: Structure and constraints for the entire database
- External or View level: Describes various user views
Download Files
Course Material
- Week 1-2: Introduction The Database Environment
- Week 3-4: The Database Development Process
- Week 5-6: Database Schema Architecture
- Week 7-8: Entity Relationship Diagram
- Week 9-10: SQL & Database Keys
- Week 11-12: Cardinality Constraints in Database
- Week 13-14: Normalization and Different type of Anomalies in Database
- Chapters 7
- Department CS & IT(SCB)
- Teacher
Mr. Jahanzaib Ali
