This schedule is tentative and may be adjusted. Latest update: 25 June
It is expected that each week's slides will be posted by Monday at the latest.
| Date | Slide Decks | Topic | Readings 6/e (5/e) | Assignments "due" |
|---|---|---|---|---|
| 07-May | 0, 1 | Introduction | 1 (1) | |
| 09-May | 2 (revised) | Relational Data Model | 3 (5) | |
| 14-May | 3 | Constraints and Updates | 3 (5) | |
| 16-May | 4 | DBMS Concepts and Architecture | 2 (2) | |
| 21-May | 5 | SQL: DDL, Select-From-Where, Set Ops | 4.1-4.3 (8.1,8.2,8.4) | |
| 23-May | 6 | Relational Algebra | 6.1-6.5 (6.1-6.5) | |
| 28-May | 7 | SQL: Aggregation and Grouped Queries | 5.1.4-5.1.5, 5.1.7-5.1.9 (8.5.4-8.5.5, 8.5.7-8.5.9) | |
| 30-May | 7 (cont'd) | SQL: Nested Queries | 5.1.2-5.1.3 (8.5.2-8.5.3) | Simple SQL |
| 04-Jun | 8 | SQL: Data and Schema Modifications | 4.4, 5.2, 5.4 (8.3, 8.6-8.7) | |
| 06-Jun | midterm 1 | |||
| 11-Jun | 9 | SQL: Null Values | 5.1.1, 5.1.6 (8.5.1, 8.5.6) | |
| 13-Jun | 10 | Views | 5.3 (8.8) | |
| 18-Jun | 11 | ER Model | 7 (3) | |
| 20-Jun | 12 | EER Model | 8 (4) | |
| 25-Jun | 13 | EER to Relation Mapping | 9 (7) | |
| 27-Jun | catch up | |||
| 02-Jul | 14 | Dependencies | 15.1-15.2, 15.5 (10.1-10.2, 10.5) | Advanced SQL |
| 04-Jul | 15 | Transaction Processing | 21 (17) | DB Design |
| 09-Jul | 16 (revised) | Concurrency Control | 21-22.1 (17-18.1) | |
| 11-Jul | midterm 2 | |||
| 16-Jul | 17 | Database Recovery | 21,23 (17,19) | |
| 18-Jul | 18 | Database Security | 24 (23) | |
| 23-Jul | 19 | Distributed Databases | 25 (25) | |
| 25-Jul | 20 | Business Analytics | 29 (29) | Transactions & Security |