Database Management Systems: CSN-351
Autumn 2016-2017


Instructor

Teaching Assistants

Class Timings

  • Lectures: MON(14:00-14:55), TUE(14:00-14:55), THU(14:00-14:55)
  • Tutorials: WED(11:05-12:00), WED(12:05-13:00), WED(18:00-18:55)

Books

  1. Abraham, H. and Sudershan, S., Database System Concepts, 6th Ed., McGraw-Hill.
  2. Elmasi, R. and Navathe, S.B., Fundamentals of Database Systems, 6th Ed., Pearson Education.
  3. Ramakrishnan, R. and Gekhre, J., Database Management Systems, 3rd Ed., McGraw-Hill.

Course Plan


Lectures

  1. Lecture 1: Overview
  2. Lecture 2: Entity-Relationship Model
  3. Lecture 3: Entity-Relationship Model (contd.)
  4. Lecture 4: Entity-Relationship Model (contd.)
  5. Lecture 5: Relational Model and SQL
  6. Lecture 6: SQL
  7. Lecture 7: SQL (contd.)
  8. Lecture 8: SQL (contd.)
  9. Lecture 9: Relational Database Design
  10. Lecture 10: Relational Database Design (contd.)
  11. Lecture 11: Relational Database Design (QA)
  12. Lecture 12: Relational Database Design (contd.)
  13. Lecture 13: Relational Database Design (contd.)
  14. Lecture 14: Relational Database Design (QA)
  15. Lecture 15: Wrapping up before Midterm
  16. Lecture 16: Transactions
  17. Lecture 17: Transaction (QA)
  18. Lecture 18: Concurrency Control
  19. Lecture 19: Concurrency Control (contd.)
  20. Lecture 20: Concurrency Control (contd.)
  21. Lecture 21: Recovery and File Structure
  22. Lecture 22: Indexing
  23. Lecture 23: B+ Tree
  24. Lecture 24: Hashing
  25. Lecture 25: Tuple Relational Calculus and Intermediate SQL
  26. Lecture 26: The Last Lecture (Contents are not in the syllabus of ETE)

Tutorials

  1. Tutorial 1: ER Diagram
  2. Tutorial 2: ER Diagram
  3. Tutorial 3: SQL
  4. Tutorial 4: SQL
  5. Solution: Tutorial 3 and 4 (SQL)
  6. Tutorial 5: Transactions and Concurrency Control

Tests

  1. Class Test 1 (Retest): Questions with Answer Keys
  2. Class Test 2: Questions with Answers
  3. Class Test 3: Questions with Solutions

Resources

  1. View Serializibility - from Stanford Infolab
  2. MongoDB Tutorial - from tutorialspoint
  3. MySQL for Windows
  4. MySQL for Ubuntu
  5. IMDB Database Dump (Download It)