The Syllabus for BPUT Database Management Systems gives students a clear understanding of the course structure and its objectives.
Here we are providing you the complete details on BPUT Database Management Systems syllabus
- To learn data models, conceptualize and depict a database system using an ER diagram.
- To understand the internal storage structures in a physical DB design.
- To know the fundamental concepts of transaction processing techniques.
Module I: (5 hours)
Introduction: Purpose of Database System -– Views of data – data models, database management system, three-schema architecture of DBMS, components of DBMS. E/R Model – Conceptual data modelling – motivation, entities, entity types, attributes relationships, relationship types, E/R diagram notation, examples.
Module II: (10 hours)
Relational Model: Relational Data Model – Concept of relations, schema-instance distinction, keys, referential integrity and foreign keys, relational algebra operators, SQL – Introduction, data definition in SQL, table, key and foreign key definitions, update behaviours. Querying in SQL, notion of aggregation, aggregation functions group by and having clauses, embedded SQL.
Module III: (7 hours)
Database Design: Dependencies and Normal forms, dependency theory – functional dependencies, Armstrong’s axioms for FD’s, closure of a set of FD’s, minimal covers, definitions of 1NF, 2NF, 3NF and BCNF, decompositions and desirable properties of them, algorithms for 3NF and BCNF normalization, 4NF, and 5NF.
Module IV: (10 hours)
Transactions: Transaction processing and Error recovery – concepts of transaction processing, ACID properties, concurrency control, locking based protocols for CC, error recovery and logging, undo, redo, undo-redo logging and recovery methods.
Module V: (8 hours)
Implementation Techniques: Data Storage and Indexes – file organizations, primary, secondary index structures, various index structures – hash-based, dynamic hashing techniques, multi-level indexes, B+ trees.
- Ability to Install, configure, and interact with a relational database management system.
- Ability to master the basics of SQL and construct queries using SQL.
- Ability to design and develop a large database with optimal query processing.
 A. Silberschatz, Henry F. Korth, and S. Sudharshan, “Database System Concepts”, 7th Ed, Tata McGraw Hill, 2019.
 C. J. Date, A. Kannan and S. Swamynathan, “An Introduction to Database Systems”, 8th ed, Pearson Education, 2006
 Ramez Elmasri and Shamkant B. Navathe, “Fundamentals of Database Systems”, 7th Edition, Pearson/Addisionwesley, 2016
 Raghu Ramakrishnan, “Database Management Systems”, Third Edition, McGraw Hill, 2003