| WK | Class/Date | Topic | Book Chapter | Homeworks | Lecture Notes |
|---|---|---|---|---|---|
| 1 | Thu 1/26 | Introduction | Ch 1 | Lecture 1 slides | |
| 2 | Tue 1/31 | Database Planning and the Entity-Relationship Model | Ch 2-3 | Project Part 1 assigned | Chapter 2 and 3 slides |
| Thu 2/2 | |||||
| 3 | Tue 2/7 |
Project Part 1 due Project Part 2 assigned |
Chapter 4 slides | ||
| Thu 2/9 | Relational Model : EER to Relational | Ch 4 | |||
| 4 | Tue 2/14 |
Part 2 Review 1 deadline (Mon) Hwk 1 assigned |
|||
| Thu 2/16 | Part 2 Review 2 deadline (Fri) | ||||
| 5 | Tue 2/21 | Quiz | old: Project Part 2 due (Wednesday) | Chapter 5 slides, Part A | |
| Thu 2/23 |
SQL, SQL, SQL (network outage complicates class here) |
Ch 5 | new: Project Part 2 due (Monday, 2/27) | ||
| 6 | Tue 2/28 |
Project Part 3 assigned Hwk 1 due |
|||
| Thu 3/2 | Hwk 2 assigned | ||||
| 7 | Tue 3/7 | SQL (cont.), class exercise | |||
| Thu 3/9 | and now some SQL -to- PL API | Chapter 5 slides, Part B | |||
| 8 | Tue 3/14 | PHP... | |||
| Thu 3/16 | Database Normalization | Ch 6 | Hwk 2 due | Chapter 6 slides | |
| 9 | Tue 3/21 | Project Part 3 due (old) | |||
| Thu 3/23 | Midterm | Project Part 4 assigned | |||
| 10 | Tue 3/28 | ||||
| Thu 3/30 | Transactions and Concurrency Control -- the secret sauce for scale-up |
Ch 9 (3rd ed) Ch 11 (4th ed) |
Project Part 3 due (3/31) (new) | Concurrency slides | |
| 11 | Tue 4/4 | School Holiday: Spring Break | |||
| Thu 4/6 | School Holiday: Spring Break | ||||
| 12 | Tue 4/11 | Project Part 5 assigned | |||
| Thu 4/13 |
Project Part 4 due (old) Project Part 6 assigned |
||||
| 13 | Tue 4/18 | Recovery - ARIES | Hwk 3 assigned | Recovery slides | |
| Thu 4/20 | Quiz | ||||
| 14 | Tue 4/25 | Project Part 4 due (new new) | |||
| Thu 4/27 | Hwk 3 due | ||||
| 15 | Tue 5/2 | Relational Query Optimization |
Ch 13 (3rd ed) Ch 10 (4th ed) |
Hwk 4 assigned | Chapter 13 slides |
| Thu 5/4 | Project Part 5 due | ||||
| 16 | Tue 5/9 |
Project Part 6 due Project Part 7 assigned |
|||
| Thu 5/11 | Optimization ending, and Database Security, the abbreviated overview | Ch 8 (3rd ed) | Chapter 8 slides | ||
| 17 | Tue 5/16 | Wrap-up the semester | Hwk 4 due | Wrap-Up slides | |
| Thu 5/18 | First day of final exams | ||||
| 18 | Tuesday 5/23 |
FINAL EXAM
Location: DBH 104 Time: 8:30 - 10:30 am |
Project Part 7 due (5 pm 5/24) |