| WK | Class/Date | Topic | Book Chapter | Homeworks | Lecture Notes |
|---|---|---|---|---|---|
| 1 | Mon 8/23 | Introduction | Ch 1 | ||
| Wed 8/25 | Database Planning and the Entity-Relationship Model | Ch 2-3 | Project Part 1 assigned | Intro slides | |
| Fri 8/27 | Chs. 2, 3 slides | ||||
| 2 | Mon 8/30 | Project Part 2 assigned | |||
| Wed 9/1 | Project Part 1 due | ||||
| Fri 9/3 | |||||
| 3 | Mon 9/6 | School Holiday: Labor Day | |||
| Wed 9/8 | Relational Model : EER to Relational | Ch 4 |
Part 2 Review 1 deadline Hwk 1 assigned |
Chapter 4 slides | |
| Fri 9/10 | |||||
| 4 | Mon 9/13 | Relational Model : Relational Algebra | Part 2 Review 2 deadline | ||
| Wed 9/15 | Project Part 2 due | ||||
| Fri 9/17 | Project Part 3 assigned | ||||
| 5 | Mon 9/20 | SQL, SQL, SQL | Ch 5 | Hwk 1 due | Chapter 5 slides |
| Wed 9/22 | |||||
| Fri 9/24 | |||||
| 6 | Mon 9/27 | more SQL, SQL, SQL | Hwk 2 assigned | ||
| Wed 9/29 | |||||
| Fri 10/1 | Quiz (and first day back in F2F classes!) | ||||
| 7 | Mon 10/4 | Project Part 3 due (old) | |||
| Wed 10/6 | |||||
| Fri 10/8 | |||||
| 8 | Mon 10/11 | still more SQL, SQL, SQL, and a class exercise |
Project Part 3 due (new) Hwk 2 due (old) |
||
| Wed 10/13 | SQL class exercise | Hwk 2 due (new) | |||
| Fri 10/15 | ... and now some SQL -to- PL API ... JDBC, ODBC... | ||||
| 9 | Mon 10/18 | HTML, PHP... | |||
| Wed 10/20 | |||||
| Fri 10/22 | Midterm | Midterm Piece | |||
| 10 | Mon 10/25 | Database Normalization | Ch 6 | Chapter 6 slides | |
| Wed 10/27 | Project Part 4 assigned | ||||
| Fri 10/29 | |||||
| 11 | Mon 11/1 | ||||
| Wed 11/3 | Transactions and Concurrency Control -- the secret sauce for scale-up | Ch 9 |
Hwk 3 assigned Project Part 5 assigned |
||
| Fri 11/5 | Chapter 9 slides | ||||
| 12 | Mon 11/8 | Project Part 4 due (old) | |||
| Wed 11/10 | |||||
| Fri 11/12 | Quiz | ||||
| 13 | Mon 11/15 | ||||
| Wed 11/17 | Crash Recovery - ARIES | Hwk 3 due | |||
| Fri 11/19 | Class cancelled today. (May have a small group-work homework, instead.) |
Project Part 4 due Project Part 6 assigned |
|||
| 14 | Mon 11/22 | Non-instructional Day, no classes. | |||
| Wed 11/24 | Non-instructional Day, no classes. | ||||
| Fri 11/26 | School Holiday: Thanksgiving | ||||
| 15 | Mon 11/29 | Prof. in DBH 287 (CS lab) to help with MySQL/PhpMyAdmin 2-3 pm. |
Project Part 7 assigned Hwk 4 assigned New ques. 6 put in Hwk 4 on 8 Dec 2021 |
||
| Wed 12/1 | Project Part 5 due | ||||
| Fri 12/3 | Project Part 6 due | ||||
| 16 | Mon 12/6 | ||||
| Wed 12/8 | Chapter 13 slides | ||||
| Fri 12/10 | Course Wrap-Up | ||||
| 17 | Wednesday 12/15 |
FINAL EXAM
Location: DBH 101 Time: 2:00 pm - 4:00 pm |
Hwk 4 due (12/13) New ques. 6 put in Hwk 4 on 8 Dec 2021 Project Part 7 due (12/17) |
