Database Management Systems - Spring 2020

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

GENERAL INFORMATION

LECTURE DETAILS

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


COURSE PLAN

No Dues

LAB DETAILS

Topic Lecture Date Lecture Topics Notes Resources
I 1-3 04-02-2020 MySQL - Data Definition Slides [PDF] [6]
II 4-6 18-02-2020 MySQL - Data Manipulation Slides [PDF] ...
III 7-9 25-02-2020 MySQL - Advanced Features Slides [PDF] ...
IV 10-12 10-03-2020 MySQL - Integrity Control Slides [PDF] ...
V 13-15 28-04-2020 MongoDB Slides [PDF], Video [MP4] [MongoDB Documentation]
... 16-18 01-05-2020 ... Video [MP4] ...


ASSIGNMENTS

Set Due Date Solutions
Assignment 1 28-02-2020 Answer Keys
Assignment 2 31-03-2020 Answer Keys
Assignment 3 30-04-2020 Answer Keys


PROJECTS

Set Due Date Allotment
Projects 30-06-2020 Details


OTHERS

Topic Details
Attendance Link
Assignment 1 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.