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