| WK | Class/Date | Topic | Book Chapter | Homeworks | Lecture Notes |
|---|---|---|---|---|---|
| 1 | Mon 8/21 | Introduction | Ch 1 | ||
| Wed 8/23 | Project Part 1 assigned | Intro slides | |||
| Fri 8/25 | Database Planning and the Entity-Relationship Model | Ch 2-3 | Chs. 2, 3 slides | ||
| 2 | Mon 8/28 | ||||
| Wed 8/30 |
Project Part 1 due Project Part 2 assigned |
||||
| Fri 9/1 | Relational Model : EER to Relational | Ch 4 | Chapter 4 slides | ||
| 3 | Mon 9/4 | School Holiday: Labor Day | |||
| Wed 9/6 | Part 2 Review 1 deadline | ||||
| Fri 9/8 | Relational Model : Relational Algebra | Hwk 1 assigned | |||
| 4 | Mon 9/11 | Part 2 Review 2 deadline (Tues nite) | |||
| Wed 9/13 | SQL, SQL, SQL | Ch 5 | Project Part 2 due | Chapter 5 slides, Part A | |
| Fri 9/15 | Quiz | Project Part 3 assigned | |||
| 5 | Mon 9/18 | Hwk 1 due | |||
| Wed 9/20 | more SQL, SQL, SQL... | ||||
| Fri 9/22 | |||||
| 6 | Mon 9/25 | ||||
| Wed 9/27 | |||||
| Fri 9/29 | Hwk 2 assigned | ||||
| 7 | Mon 10/2 | class exercise on SQL | Today's class work | ||
| Wed 10/4 | Chapter 5, Part B | ||||
| Fri 10/6 | |||||
| 8 | Mon 10/9 | Project Part 3 due (old) | |||
| Wed 10/11 | Class lecture cancelled due to 'Great Minds in STEM' conference travel | ||||
| Fri 10/13 | Class lecture cancelled. Recommended: meet in the classroom with your group at class time to polish Part 3! | Project Part 3 due (new) | |||
| 9 | Mon 10/16 | Database Normalization | Ch 6 | Hwk 2 due | Chapter 6 slides |
| Wed 10/18 | Midterm | ||||
| Fri 10/20 | |||||
| 10 | Mon 10/23 | Project Part 4 assigned | |||
| Wed 10/25 | |||||
| Fri 10/27 | Transactions and Concurrency Control -- the secret sauce for scale-up | Ch 9 (3rd ed), Ch 11 (4th ed) | Chapter 9, Part A | ||
| 11 | Mon 10/30 | ||||
| Wed 11/1 |
Hwk 3 assigned Project Part 5 assigned |
||||
| Fri 11/3 | |||||
| 12 | Mon 11/6 | Crash Recovery - ARIES | Project Part 4 due | Chapter 9, Part B | |
| Wed 11/8 | Quiz | ||||
| Fri 11/10 | School Holiday: Veteran's Day | ||||
| 13 | Mon 11/13 | Hwk 3 due | |||
| Wed 11/15 | |||||
| Fri 11/17 | Project Part 6 assigned | ARIES activity | |||
| 14 | Mon 11/20 | Non-instructional Day, no classes. | |||
| Wed 11/22 | Non-instructional Day, no classes. | ||||
| Fri 11/24 | School Holiday: Thanksgiving | ||||
| 15 | Mon 11/27 | Relational Query Optimization | Ch 13 (3rd ed), Ch 10 (4th ed) | Project Part 5 due (old) | Chapter 13 slides |
| Wed 11/29 | Project Part 7 assigned | ||||
| Fri 12/1 | Project Part 6 due | ||||
| 16 | Mon 12/4 |
Project Part 5 due (new) Hwk 4 assigned |
|||
| Wed 12/6 | |||||
| Fri 12/8 | Course Wrap-Up | ||||
| 17 | Friday 12/15 |
FINAL EXAM
Location: DBH 101 Time: 8:30 am - 10:30 am |
Hwk 4 due (12/13) Project Part 7 cancelled, Fall 2023 |