Database Management Systems - Spring 2021

MTech (CS) : 1st Year, 2nd Semester

GENERAL INFORMATION

LECTURE DETAILS

Topic Lecture Date Lecture Topics Notes Resources
0 1-2 30-03-2021 Introduction to Databases Slides [PDF] [R1, R2, R3, R4, R5]
I 3-4 06-04-2021 Mathematical Preliminaries Slides [PDF] [R2, R11, Vardi (1982)]
... 5-6 09-04-2021 ... ... ...
II 7-8 13-04-2021 Relational Data Model Slides [PDF] [R2, R4, Codd (1970)]
... 9-10 16-04-2021 ... ... ...
III 11-12 27-04-2021 Database Indexing Slides [PDF] [R2]
IV 13-14 07-05-2021 Database Structuring and Querying with SQL Slides [PDF] [R6, R7, R8]
V 15-16 11-05-2021 Database Normalization Slides [PDF] [Codd (1970), Codd (1971), Codd (1974), Fagin (1977), Fagin (1979), Fagin (1981), Zaniolo (1982), Date (2002), Date (2006)]
... 17-18 18-05-2021 ... ... ...
... 19-20 21-05-2021 ... ... ...
VI 21-22 25-05-2021 Query Optimization Slides [PDF] [R9]
... 23-24 28-05-2021 ... ... ...
... 25-26 01-06-2021 ... ... ...
VII 27-28 04-06-2021 Transaction Processing Slides [PDF] [R2]
VIII 29-30 08-06-2021 Concurrency Control Slides [PDF] [R2]
... 31-32 11-06-2021 ... ... ...
... 33-34 15-06-2021 ... ... ...
IX 36-36 18-06-2021 Database Recovery Slides [PDF] [R2, Mohan (1992)]
X 37-38 22-06-2021 Big Data Management Slides [PDF] [R10, Cattell (2011), Mirrokni (2017)]
... 39-40 25-06-2021 ... ... ...
XI 41-42 29-06-2021 Distributed Databases Slides [PDF] [2]
XII 43-44 02-07-2021 Graph Databases Slides [PDF]


COURSE PLAN

No dues

LAB DETAILS

Topic Lecture Date Lecture Topics Notes Resources
0 1-2 07-04-2021 MySQL - Getting Ready Slides [PDF] [6]
I 3-4 12-05-2021 MySQL - Data Definition Slides [PDF] [6]
II 5-6 19-05-2021 MySQL - Data Manipulation Slides [PDF] ...
III 7-8 02-06-2021 MySQL - Advanced Features Slides [PDF] ...
IV 9-10 09-06-2021 MySQL - Integrity Control Slides [PDF] ...
... 11-12 23-06-2021 ... ... ...
V 13-14 30-06-2021 MongoDB Slides [PDF] [MongoDB Documentation]


ASSIGNMENTS

Set Due Date Solutions
Assignment 1 15-04-2021 Answer Keys
Assignment 2 15-05-2021 Answer Keys
Assignment 3 15-06-2021 Answer Keys
Assignment 4 15-07-2021 Answer Keys
Assignment 5 15-08-2021 Answer Keys


PROJECTS

Set Due Date Allotment
Projects 31-08-2021 Details


OTHERS

Topic Details
Attendance Link
Assignment 1 marks Link
Assignment 2 marks Link
Assignment 3 marks Link
Assignment 4 marks Link
Assignment 5 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.