Dates | Topics | Lab | Assignments Quizzes |
Project | Exams |
Week 1 | Introduction Data Models |
- | - | - | - |
Week 2 | Relational DBMS Basics ER Modelling (I) |
Lab 1 | - | - | - |
Week 3 | Database design (II) SQL-1 |
Lab 2 | A1 | - | - |
Week 4 | SQL-2 Relational Algebra |
Lab 3 | A2 | Ideas | - |
Week 5 | Datalog SQL-3 |
Lab 4 | A3 | - | - |
Week 6 | SQL-4 Query Examples |
Lab 5 | A4 | - | - |
- | February 18 - 21 Spring Reading Week |
- | A5 | - | - |
Week 7 | Midterm Review In-class Midterm |
Lab 6 | A6 | Proposal | Midterm |
Week 8 | Database Application (I) Database Application (II) (optional) Project Information |
Lab 7 | - | - | - |
Week 9 | Functional Dependency Normal Forms |
Lab 8 | A7 | - | - |
Week 10 | Transaction Management (Anomalies) Schedules |
Lab 9 | A8 | Implementation | - |
Week 11 | Locks and Timestamps Recovery |
work on project | A9 | - | - |
Week 12 | Indexing Indexing |
work on project | AA | Report | - |
Week 13 | Security Review |
Lab A | - | Submit | - |