Database Management System (DBMS) – Full Syllabus for CSE Students
Complete module-wise breakdown, lab syllabus, and recommended books – designed for CSE/IT undergraduate students.
Module 1: Introduction to Databases
- Definition of Data, Information, Database, DBMS
- Advantages and disadvantages of DBMS over file systems
- Data Independence and Data Abstraction – Physical, Logical, View
- DBMS Architecture – 1-tier, 2-tier, 3-tier
- Data Models – Hierarchical, Network, Relational, Object-oriented
- Database Languages – DDL, DML, DCL, TCL
Module 2: Entity–Relationship (ER) Model
- Entity, Attributes, Relationships and their types
- ER Diagrams and EER Concepts – Specialization, Generalization, Aggregation
- Keys: Super Key, Candidate Key, Primary Key, Foreign Key
- Mapping ER Model to Relational Model
Module 3: Relational Model & Relational Algebra
- Relational Data Model – Schema, Tuples, Attributes, Domains
- Integrity Constraints – Domain, Key, Entity, Referential
- Relational Algebra Operations – Selection, Projection, Join, Union, Difference
- Extended Operations – Division, Rename, Aggregation
Module 4: Structured Query Language (SQL)
- DDL: CREATE, ALTER, DROP
- DML: SELECT, INSERT, UPDATE, DELETE
- Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY, FOREIGN
- Joins – Inner, Outer, Cross
- Subqueries, Views, Aggregate Functions, GROUP BY, HAVING, ORDER BY
- DCL: GRANT, REVOKE | TCL: COMMIT, ROLLBACK
Module 5: Normalization and Database Design
- Functional Dependencies
- 1NF, 2NF, 3NF, BCNF, 4NF, 5NF
- Decomposition – Lossless Join and Dependency Preservation
- Denormalization – Concepts and Trade-offs
Module 6: Transaction Management & Concurrency Control
- Concept and Properties of Transactions (ACID)
- Transaction States and Schedules
- Serializability – Conflict and View
- Lock-based and Timestamp-based Concurrency Control
- Deadlock Handling
Module 7: Recovery System
- Failure Types – Transaction, System, Media
- Recovery Techniques – Deferred and Immediate Updates
- Checkpoint, Shadow Paging, Log-based Recovery
Module 8: File Organization & Indexing
- Sequential, Indexed, and Hashed File Organization
- Indexing – Primary, Secondary, Dense, Sparse
- B-Tree, B+ Tree, and Hash-based Indexing
Module 9: Database Security
- Database Security Issues – Authentication, Authorization
- Access Control – DAC, MAC, RBAC
- Encryption and Data Privacy
Module 10: Advanced Topics
- Distributed Databases and Data Warehousing
- Data Mining and OLAP Concepts
- NoSQL and Cloud Databases
- Object-relational Databases
DBMS Lab Syllabus
- Using MySQL / Oracle / PostgreSQL
- Creating Databases, Tables, and Schemas
- Insert, Update, Delete, and Retrieve Data
- Join, Subquery, Aggregate Function Implementation
- Views, Index, Trigger, and Stored Procedure Creation
- Transaction Control – COMMIT, ROLLBACK
- Normalization and Mini Project Implementation
Recommended Books
- Silberschatz, Korth & Sudarshan – Database System Concepts
- Raghu Ramakrishnan & Gehrke – Database Management Systems
- Elmasri & Navathe – Fundamentals of Database Systems
- Groff & Weinberg – SQL: The Complete Reference