| WK | Class/Date | Topic | Book Chapter | Homeworks | Lecture Notes |
|---|---|---|---|---|---|
| 1 | Fri 8/23 | Introduction | Ch 1 | ||
| 2 | Mon 8/26 | Database Planning and the Entity-Relationship Model | Ch 2-3 | Project Part 1 assigned | Intro slides |
| Wed 8/28 | Project Part 2 assigned | ||||
| Fri 8/30 |
Chs. 2, 3 slides (6xpg) Chs. slides (3xpg) |
||||
| 3 | Mon 9/2 | School Holiday: Labor Day | |||
| Wed 9/4 | Project Part 1 due | ||||
| Fri 9/6 | Relational Model : EER to Relational | Ch 4 | Part 2 Review 1 deadline | Chapter 4 slides | |
| 4 | Mon 9/9 | Part 2 Review 2 deadline (9/10) | |||
| Wed 9/11 | Relational Model : Relational Algebra | Project Part 2 due | |||
| Fri 9/13 | |||||
| 5 | Mon 9/16 | Relational Algebra practice, practice | Hwk 1 assigned | ||
| Wed 9/18 | Class cancelled due to Tapia Celebration - Group Work Day instead | Mini-Homework 1 assigned | |||
| Fri 9/20 | Class cancelled due to Tapia Celebration | ||||
| 6 | Mon 9/23 |
Quiz SQL, SQL, SQL |
Ch 5 | Project Part 3 assigned | |
| Wed 9/25 | SQL, SQL, SQL | Mini-Homework 1 due | Chapter 5 slides | ||
| Fri 9/27 | Hwk 1 due | ||||
| 7 | Mon 9/30 | ||||
| Wed 10/2 | |||||
| Fri 10/4 | ... Still SQL... | Hwk 2 assigned | SQL exercise | ||
| 8 | Mon 10/7 | ||||
| Wed 10/9 | |||||
| Fri 10/11 | Database Normalization | Ch 6 | |||
| 9 | Mon 10/14 | Project Part 3 due | |||
| Wed 10/16 | Project Part 4 assigned | Chapter 6 slides | |||
| Fri 10/18 | Midterm (A hint) | ||||
| 10 | Mon 10/21 | Hwk 2 due | |||
| Wed 10/23 | |||||
| Fri 10/25 | Transactions and Concurrency Control -- the secret sauce for scale-up | Ch 9 | Chapter 9 slides | ||
| 11 | Mon 10/28 | Hwk 3 assigned | |||
| Wed 10/30 | Project Part 5 assigned | ||||
| Fri 11/1 | Project Part 4 due (old) | ||||
| 12 | Mon 11/4 | ||||
| Wed 11/6 | |||||
| Fri 11/8 | Relational Query Optimization | Ch 13 | Project Part 4 due (new) | ||
| 13 | Mon 11/11 | School Holiday: Veteran's Day | |||
| Wed 11/13 | Quiz |
Hwk 3 due Hwk 4 assigned |
|||
| Fri 11/15 | Project Part 6 assigned | ||||
| 14 | Mon 11/18 | Chapter 13 slides | |||
| Wed 11/20 |
Project Part 5 due Project Part 7 assigned |
||||
| Fri 11/22 | |||||
| 15 | Mon 11/25 | Database Security | Ch 8 | Project Part 6 due | Chapter 8 slides |
| Wed 11/27 | Homework help day. Dr Thomas will be in CS Lab to help with Project Part 7, etc. No lecture. | ||||
| Fri 11/29 | School Holiday: Thanksgiving | ||||
| 16 | Mon 12/2 | Go over Homework 3 solutions | Hwk 4 due | ||
| Wed 12/4 | |||||
| Fri 12/6 | B+-Tree Introduction | ||||
| 17 | Mon 12/9 | Course Wrap-Up | |||
| 18 | Monday 12/16 |
FINAL EXAM
Location: DBH 104 Time: 2:00 pm - 4:00 pm |
Project Part 7 due (12/17) |
