| WK | Class/Date | Topic | Book Chapter | Homeworks | Lecture Notes |
|---|---|---|---|---|---|
| 1 | Mon 8/22 | Introduction | Ch 1 | ||
| Wed 8/24 | Project Part 1 assigned | Intro slides | |||
| Fri 8/26 | Database Planning and the Entity-Relationship Model | Ch 2-3 | Chs. 2, 3 slides | ||
| 2 | Mon 8/29 | ||||
| Wed 8/31 | Relational Model : EER to Relational | Ch 4 |
Project Part 1 due Project Part 2 assigned |
Chapter 4 slides | |
| Fri 9/2 | |||||
| 3 | Mon 9/5 | School Holiday: Labor Day | |||
| Wed 9/7 | Part 2 Review 1 deadline | ||||
| Fri 9/9 | Relational Model : Relational Algebra | ||||
| 4 | Mon 9/12 | SQL, SQL, SQL | Ch 5 |
Part 2 Review 2 deadline Hwk 1 assigned |
Chapter 5 slides |
| Wed 9/14 |
Project Part 2 due Project Part 3 assigned |
||||
| Fri 9/16 | Quiz | ||||
| 5 | Mon 9/19 | Hwk 1 due | |||
| Wed 9/21 | more SQL, SQL, SQL... | Hwk 2 assigned | |||
| Fri 9/23 | |||||
| 6 | Mon 9/26 | still more SQL, SQL, SQL, and a class exercise | |||
| Wed 9/28 | and now some SQL -to- PL API | ||||
| Fri 9/30 | |||||
| 7 | Mon 10/3 | Database Normalization | Ch 6 | Project Part 3 due (old) | Chapter 6 slides |
| Wed 10/5 | Class cancelled due to 'Great Minds in STEM' conference travel | ||||
| Fri 10/7 | Class on Zoom today, due to travel | Hwk 2 due (old) | |||
| 8 | Mon 10/10 | Hwk 2 due (new) | |||
| Wed 10/12 |
Project Part 3 due Project Part 4 assigned |
||||
| Fri 10/14 | Midterm | ||||
| 9 | Mon 10/17 | ||||
| Wed 10/19 | Transactions and Concurrency Control -- the secret sauce for scale-up | Ch 9 | Chapter 9 slides | ||
| Fri 10/21 | Hwk 3 assigned | ||||
| 10 | Mon 10/24 | ||||
| Wed 10/26 | Crash Recovery - ARIES |
Project Part 4 due Project Part 5 assigned |
|||
| Fri 10/28 | |||||
| 11 | Mon 10/31 | Project Part 4 due (not really) | |||
| Wed 11/2 | Relational Query Optimization | Ch 13 |
ARIES activity Chapter 13 slides |
||
| Fri 11/4 |
Hwk 3 due Project Part 4 due (new-new) |
||||
| 12 | Mon 11/7 | ||||
| Wed 11/9 | Quiz | ||||
| Fri 11/11 | School Holiday: Veteran's Day | ||||
| 13 | Mon 11/14 | ||||
| Wed 11/16 | |||||
| Fri 11/18 | No regular class today. Prof. in DBH 288 (CS lab) to help with MySQL/PhpMyAdmin 3-4 pm. | Project Part 6 assigned | |||
| 14 | Mon 11/21 | Non-instructional Day, no classes. | |||
| Wed 11/23 | Non-instructional Day, no classes. | ||||
| Fri 11/25 | School Holiday: Thanksgiving | ||||
| 15 | Mon 11/28 | Query Optimization |
Project Part 7 assigned |
||
| Wed 11/30 | Database Security | Ch 8 |
Project Part 5 due Hwk 4 assigned |
Chapter 8 slides | |
| Fri 12/2 | |||||
| 16 | Mon 12/5 | ||||
| Wed 12/7 | Project Part 6 due | ||||
| Fri 12/9 | Course Wrap-Up | ||||
| 17 | Wednesday 12/14 |
FINAL EXAM
Location: Science 137 Time: 2:00 pm - 4:00 pm |
Hwk 4 due (12/16) Project Part 7 due (12/19) |