Database Management Systems - Spring 2026

BSDS : 2nd Year, 2nd Semester

GENERAL INFORMATION

LECTURE DETAILS

Topic Lecture Date Lecture Topics Notes Resources
0 1-2 28-01-2026 Introduction to Databases Slides [PDF] [R1, R2, R3, R4, R5]
I 3-4 30-01-2026 Relational Algebra Slides [PDF] [R2, R11, Vardi (1982)]
... 5-6 04-02-2026 ... ... ...
... 7-8 06-02-2026 ... ... ...
II 9-10 11-02-2026 Entity-Relationship Data Model Slides [PDF] [R2, R4, Codd (1970)]
... 11-12 13-02-2026 ... ... ...
III 13-14 18-02-2026 Entity Relationship Diagram Slides [PDF] [R6, R7, R8]
IV 15-16 20-02-2026 Database Structuring and Querying with SQL Slides [PDF] [R6, R7, R8]
V 17-18 25-02-2026 Database Indexing Slides [PDF] [R2]
... 19-20 27-02-2026 ... ... ...
VI 21-22 27-02-2026 Database Normalization Slides [PDF] [Codd (1970), Codd (1971), Codd (1974), Fagin (1977), Date (2006)]
... 23-24 06-03-2026 ... ... ...
... 25-26 11-03-2026 ... ... ...
Mid-semester examination break (16-03-2026 to 20-03-2026) Mid Semester Paper, Answer Keys
VII 27-28 25-03-2026 Query Optimization Slides [PDF] [R9]
... 29-30 27-03-2026 ... ... ...
... 31-32 01-04-2026 ... ... ...
VIII 33-34 08-04-2026 Transaction Processing Slides [PDF] [R2]
... 35-36 10-04-2026 ... ... ...


COURSE PLAN

Topic Lecture Date Lecture Topics Notes Resources
IX 37-38 15-04-2026 Concurrency Control Slides [PDF] [R2]
... 39-40 17-04-2026 ... ... ...
... 41-42 22-04-2026 ... ... ...
X 43-44 24-04-2026 NoSQL Slides [PDF] [R10, Cattell (2011), Mirrokni (2017)]


LAB DETAILS

Topic Lecture Date Lecture Topics Notes Resources
0 1-2 16-02-2026 MySQL - Getting Ready Slides [PDF] [6]
I 3-4 23-02-2026 MySQL - Data Definition Slides [PDF] [6]
II 5-6 02-03-2026 MySQL - Data Manipulation Slides [PDF] ...
... 7-8 09-03-2026 ... ... ...
... 9-10 23-03-2026 ... ... ...
III 11-12 30-03-2026 MySQL - Advanced Features Slides [PDF] ...
IV 13-14 06-04-2026 MySQL - Integrity Control Slides [PDF] ...
V 15-16 13-04-2026 MongoDB Slides [PDF] [MongoDB Documentation]
VI 17-18 20-04-2026 MySQL - Professional Coding Slides [PDF] [6, 8, 9]


ASSIGNMENTS

Set Due Date Solutions
Assignment 1 15-02-2026 Answer Keys
Assignment 2 15-03-2026 Answer Keys
Assignment 3 (Lab Test) 15-04-2026 Answer Keys


PROJECTS

Set Due Date Allotment
Projects 15-05-2026 Details


OTHERS

Topic Details
Attendance Link
Assignment 1 marks Link
Assignment 2 marks Link
Assignment 3 marks Link
Project marks Link


REFERENCES

  1. C. J. Date, An Introduction to Database Systems, Pearson Education, Inc., 8th Edition, 2006.
  2. A. Silberschatz, H. F. Korth and S. Sudarshan, Database System Concepts, Tata McGraw-Hill, 6th Edition, 2011.
  3. R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, Pearson Education, Inc., 4th Edition, 2004.
  4. R. Ramakrishnan and J. Gehrke, Database Management Systems, McGraw-Hil, 3rd Edition, 2007.
  5. H. Garcia-Molina, J. D. Ullman and J. Widom, Database Systems: The Complete Book, Pearson Education, Inc., 2nd Edition, 2009.
  6. G. Harrison and S. Feuerstein, MySQL stored procedure programming. O'Reilly Media, Inc., 2006.
  7. K. Loney, Oracle Database 11g - The Complete Reference, McGraw-Hill, Inc., 2008.
  8. I. Bayross, SQL, PL/SQL: The Programming Language of Oracle, BPB Publications, 6th Edition, 2010.
  9. G. Fritchey, SQL Server Query Performance Tuning, Apress, 4th Edition, 2011.
  10. P. J. Sadalage and M. Fowler, NoSQL distilled: a brief guide to the emerging world of polyglot persistence, Pearson Education, Inc., 1st Edition, 2013.
  11. C. J. Date and H. Darwen, Database Explorations: Essays on The Third Manifesto and Related Topics, Trafford Publishing, 2010.