| WK | Class/Date | Topic | Book Chapter | Homeworks | Lecture Notes |
|---|---|---|---|---|---|
| 1 | Wed 1/29 | Introduction | Ch 1 | Intro slides | |
| Fri 1/31 | Database Planning and the Entity-Relationship Model | Ch 2, 3 | Project Part 1 assigned | ||
| 2 | Mon 2/3 | Chs. 2, 3 slides | |||
| Wed 2/5 | |||||
| Fri 2/7 | Project Part 1 due | ||||
| 3 | Mon 2/10 | Relational Model : EER to Relational | Ch 4 | Project Part 2 assigned | Chapter 4 slides |
| Wed 2/12 | |||||
| Fri 2/14 | Hwk 1 assigned | ||||
| 4 | Mon 2/17 | Relational Model : Relational Algebra |
Part 2 Review 1 deadline |
R.A. exercise | |
| Wed 2/19 | R.A., plus SQL, SQL, SQL | Ch 5 | Chapter 5 slides, Part A | ||
| Fri 2/21 | |||||
| 5 | Mon 2/24 |
Part 2 Review 2 deadline Hwk 1 due |
|||
| Wed 2/26 | Project Part 2 due | ||||
| Fri 2/28 | Quiz | ||||
| 6 | Mon 3/3 | ||||
| Wed 3/5 | |||||
| Fri 3/7 | Project Part 3 assigned | ||||
| 7 | Mon 3/10 | a SQL class exercise | Hwk 2 assigned | Chapter 5 slides, Part B | |
| Wed 3/12 | and now some SQL -to- PL API | ||||
| Fri 3/14 | |||||
| 8 | Mon 3/17 | Database Normalization | Ch 6 | Chapter 6 slides | |
| Wed 3/19 | |||||
| Fri 3/21 | |||||
| 9 | Mon 3/24 | Project Part 3 due | |||
| Wed 3/26 | Midterm | ||||
| Fri 3/28 | Class cancelled due to computer science education conference. | Hwk 2 due | |||
| 10 | Mon 3/31 | School Holiday: Cesar Chavez Day | |||
| Wed 4/2 | School Holiday: Spring Break | ||||
| Fri 4/4 | School Holiday: Spring Break | ||||
| 11 | Mon 4/7 | Project Part 4 assigned | |||
| Wed 4/9 | |||||
| Fri 4/11 | Transactions and Concurrency Control -- the secret sauce for scale-up | Ch 9 (3rd ed), Ch 11 (4th ed) | Chapter 9 slides | ||
| 12 | Mon 4/14 | SQL quiz today | Project Part 5 assigned | ||
| Wed 4/16 | SQL quiz today | Project Part 4 due (original) | |||
| Fri 4/18 | Class cancelled due to business meeting. | ||||
| 13 | Mon 4/21 |
Project Part 4 due (new) Hwk 3 assigned |
|||
| Wed 4/23 | SQL quiz today | ||||
| Fri 4/25 | Quiz | Project Part 6 assigned | |||
| 14 | Mon 4/28 | Crash Recovery - ARIES | |||
| Wed 4/30 | |||||
| Fri 5/2 | Hwk 3 due | ||||
| 15 | Mon 5/5 | Project Part 5 due | |||
| Wed 5/7 | Relational Query Optimization | Ch 13 (3rd ed), Ch 10 (4th ed) | Project Part 7 assigned | Chapter 13 slides | |
| Fri 5/9 | Warrior Day. No class. | Project Part 6 due | |||
| 16 | Mon 5/12 |
Hwk 4 assigned
(Fixed 5/17) |
|||
| Wed 5/14 | |||||
| Fri 5/16 | |||||
| 17 | Wednesday 5/21 |
FINAL EXAM
Location: DBH 113 Time: 2:00 pm - 4:00 pm |
Hwk 4 due (5/19) Project Part 7 due (5/23) |