Database Management Systems
Subject Overview
Database Management Systems covers DBMS fundamentals and the three-level architecture, data models (ER, hierarchical, network, relational), the relational data model with normalization, and database protection and distributed databases. A 5-credit core theory paper.
Unit-wise Syllabus
4 units — click WhatsApp below to get the full notes for each
Unit 1: DBMS overview
File processing systems vs database systems, database administrator responsibilities, physical and logical data independence, three-level architecture — external, conceptual and internal levels
Unit 2: Data models
Entity-Relationship model, hierarchical model, network model, relational model, comparison of network/hierarchical/relational models
Unit 3: The relational data model
Relational database, relational algebra and calculus, SQL, dependencies — functional dependency, multi-valued dependency, join dependency, normalization
Unit 4: Database protection and distributed databases
Recovery, concurrency management, database security, integrity and control, disaster management, structure and design of distributed databases