| WK | Class/Date | Topic | Book Chapter | Homeworks | Lecture Notes |
|---|---|---|---|---|---|
| 1 | Fri 1/26 | Introduction | Ch 1 | Intro slides | |
| 2 | Mon 1/29 | Database Planning and the Entity-Relationship Model | Ch 2, 3 | Project Part 1 assigned | Chs. 2, 3 slides |
| Wed 1/31 | |||||
| Fri 2/2 | |||||
| 3 | Mon 2/5 |
Project Part 1 due Project Part 2 assigned |
|||
| Wed 2/7 | Relational Model : EER to Relational | Ch 4 | Chapter 4 slides | ||
| Fri 2/9 | |||||
| 4 | Mon 2/12 |
Part 2 Review 1 deadline Hwk 1 assigned |
|||
| Wed 2/14 | Relational Model : Relational Algebra | ||||
| Fri 2/16 | |||||
| 5 | Mon 2/19 | SQL, SQL, SQL | Part 2 Review 2 deadline | Chapter 5 slides, Part A | |
| Wed 2/21 | Project Part 2 due | ||||
| Fri 2/23 | Quiz | ||||
| 6 | Mon 2/26 | Hwk 1 due | |||
| Wed 2/28 | more SQL, SQL, SQL... | ||||
| Fri 3/1 | Project Part 3 assigned | ||||
| 7 | Mon 3/4 | a SQL class exercise | Chapter 5 slides, Part B | ||
| Wed 3/6 | and now some SQL -to- PL API | ||||
| Fri 3/8 | |||||
| 8 | Mon 3/11 | Database Normalization | Ch 6 | Chapter 6 slides | |
| Wed 3/13 | Hwk 2 assigned | ||||
| Fri 3/15 | |||||
| 9 | Mon 3/18 | Transactions and Concurrency Control -- the secret sauce for scale-up | Ch 9 (3rd ed), Ch 11 (4th ed) | Chapter 9 slides | |
| Wed 3/20 | (Slide from today's midterm discussion) |
Project Part 3 due (old) Project Part 4 assigned |
|||
| Fri 3/22 | Midterm | ||||
| 10 | Mon 3/25 | Hwk 2 due | |||
| Wed 3/27 | |||||
| Fri 3/29 | Project Part 3 due (new new) | ||||
| 11 | Mon 4/1 | School Holiday: Spring Break | |||
| Wed 4/3 | School Holiday: Spring Break | ||||
| Fri 4/5 | School Holiday: Spring Break | ||||
| 12 | Mon 4/8 | ||||
| Wed 4/10 | Crash Recovery - ARIES |
Project Part 4 due (original deadline) Hwk 3 assigned |
|||
| Fri 4/12 | Project Part 4 due (new deadline) | ||||
| 13 | Mon 4/15 | Relational Query Optimization | Ch 13 (3rd ed), Ch 10 (4th ed) | Chapter 13 slides | |
| Wed 4/17 | Exam Q & A | ||||
| Fri 4/19 | Quiz | ||||
| 14 | Mon 4/22 | Project Part 5 assigned | |||
| Wed 4/24 |
Hwk 3 due Project Part 6 assigned |
||||
| Fri 4/26 | Class cancelled due to professor business meeting. Work on your project! | ||||
| 15 | Mon 4/29 | ||||
| Wed 5/1 | |||||
| Fri 5/3 | |||||
| 16 | Mon 5/6 | Database Security | Ch 8 |
Project Part 5 due Hwk 4 assigned Project Part 7 assigned |
Chapter 8 slides |
| Wed 5/8 | |||||
| Fri 5/10 | Warrior Day. No class. | Project Part 6 due | |||
| 17 | Mon 5/13 | ||||
| Wed 5/15 | Course Wrap-Up | Wrap-Up slides | |||
| Fri 5/17 | Reading Day | Hwk 4 due | |||
| 18 | Wednesday 5/22 |
FINAL EXAM
Location: DBH 165 Time: 2:00 pm - 4:00 pm |
Project Part 7 due (5/24) |