| WK | Class/Date | Topic | Book Chapter | Homeworks | Lecture Notes |
|---|---|---|---|---|---|
| 1 | Thu 1/28 | Introduction | Ch 1 | Lecture 1 slides | |
| 2 | Tue 2/2 | Database Planning and the Entity-Relationship Model | Ch 2-3 | Project Part 1 assigned | Chapter 2 and 3 slides |
| Thu 2/4 | |||||
| 3 | Tue 2/9 |
Project Part 1 due Project Part 2 assigned |
|||
| Thu 2/11 | Relational Model : EER to Relational | Ch 4 | Chapter 4 slides | ||
| 4 | Tue 2/16 | Part 2 Review 1 deadline | |||
| Thu 2/18 | ... and Relational Algebra | Part 2 Review 2 deadline | |||
| 5 | Tue 2/23 | Relational Algebra, and SQL, SQL, SQL | Ch 5 |
Project Part 2 due Project Part 3 assigned Hwk 1 assigned |
Chapter 5 slides |
| Thu 2/25 | Quiz | ||||
| 6 | Tue 3/2 | ||||
| Thu 3/4 | Hwk 1 due | ||||
| 7 | Tue 3/9 | SQL (cont.), and class exercise | |||
| Thu 3/11 | SQL (cont.), more class exercise |
Project Part 3 due Hwk 2 assigned |
|||
| 8 | Tue 3/16 | and now some SQL -to- PL API | |||
| Thu 3/18 | Midterm | ||||
| 9 | Tue 3/23 | PHP... | |||
| Thu 3/25 | Database Normalization | Ch 6 | Hwk 2 due | Chapter 6 slides | |
| 10 | Tue 3/30 | Project Part 4 assigned | |||
| Thu 4/1 | |||||
| 11 | Tue 4/6 | School Holiday: Spring Break | |||
| Thu 4/8 | School Holiday: Spring Break | ||||
| 12 | Tue 4/13 | Transactions and Concurrency Control -- the secret sauce for scale-up | Ch 9 | Project Part 5 assigned | Chapter 9 slides |
| Thu 4/15 | Hwk 3 assigned | ||||
| 13 | Tue 4/20 | Project Part 4 due (originally) Project Part 6 assigned | |||
| Thu 4/22 | Quiz | ||||
| 14 | Tue 4/27 | Project Part 4 due (new) | |||
| Thu 4/29 | Hwk 3 due | ||||
| 15 | Tue 5/4 | Relational Query Optimization | Ch 13 |
Project Part 5 due Project Part 7 assigned |
Chapter 13 slides |
| Thu 5/6 | |||||
| 16 | Tue 5/11 |
Project Part 6 due Hwk 4 assigned |
|||
| Thu 5/13 | |||||
| 17 | Tue 5/18 | Wrap-up | Wrap-Up slides | ||
| Thu 5/20 | First day of final exams. | ||||
| 18 | Thursday 5/20 |
FINAL EXAM
Location: Zoom?? Time: 2 - 4 pm |
Project Part 7 due (5/24) Hwk 4 due (5/26) |