| WK | Class/Date | Topic | Book Chapter | Homeworks | Lecture Notes |
|---|---|---|---|---|---|
| 1 | Tue 1/28 | Introduction | Ch 1 | Lecture 1 slides | |
| Thu 1/30 | Database Planning and the Entity-Relationship Model | Ch 2-3 | Project Part 1 assigned | Chapter 2 and 3 slides | |
| 2 | Tue 2/4 | Project Part 2 assigned | |||
| Thu 2/6 | Relational Model : EER to Relational | Ch 4 | Project Part 1 due | ||
| 3 | Tue 2/11 |
Part 2 Review 1 deadline |
Chapter 4 slides | ||
| Thu 2/13 | Relational Model : Relational Algebra |
Hwk 1 assigned Part 2 Review 2 deadline (2/17) |
|||
| 4 | Tue 2/18 |
Relational Algebra SQL, SQL, SQL |
Ch 5 | Project Part 2 due | Chapter 5 slides |
| Thu 2/20 |
(Original Quiz date.) Abbreviated lecture, due to visitor. Group work day, Project Part 3. |
Project Part 3 assigned | |||
| 5 | Tue 2/25 | Quiz | |||
| Thu 2/27 | Hwk 1 due | ||||
| 6 | Tue 3/3 | Hwk 2 assigned | |||
| Thu 3/5 | |||||
| 7 | Tue 3/10 | ||||
| Thu 3/12 | |||||
| 8 | Tue 3/17 | Midterm (postponed due to COVID-19 campus closure) | Project Part 3 due | ||
| Thu 3/19 | Midterm moved to Tuesday. Campus closed today. | Hwk 2 due (Friday) | |||
| 9 | Tue 3/24 | School Holiday: Spring Break | |||
| Thu 3/26 | School Holiday: Spring Break | ||||
| 10 | Tue 3/31 | School Holiday: Cesar Chavez Day | Project Part 4 assigned | ||
| Thu 4/2 |
Link to Zoom meeting Database Normalization (also, midterm review, etc) |
Ch 6 | Chapter 6 slides | ||
| 11 | Tue 4/7 | Midterm | |||
| Thu 4/9 | |||||
| 12 | Tue 4/14 | Project Part 5 assigned | |||
| Thu 4/16 | Transactions and Concurrency Control -- the secret sauce for scale-up | Ch 9 | Project Part 4 due (old deadline) | Chapter 9 slides | |
| 13 | Tue 4/21 | Quiz (original date) | |||
| Thu 4/23 |
Project Part 4 due (new) Project Part 6 assigned Hwk 3 assigned |
||||
| 14 | Tue 4/28 | Quiz (new date) | |||
| Thu 4/30 |
Project Part 5 due Project Part 7 assigned |
||||
| 15 | Tue 5/5 | Recovery, and Project Part 7 set-up tutorial | Project Part 6 due | ||
| Thu 5/7 | Relational Query Optimization | Ch 13 | Chapter 13 slides | ||
| 16 | Tue 5/12 | ||||
| Thu 5/14 | Wrap-up | Hwk 3 due | Wrap-Up slides | ||
| 17 | Tuesday 5/19 |
FINAL EXAM
Location: On-line Time: 2-4 pm |
Project Part 7 due (5/20) May 20: Deadline extended to 5/22. 5pts extra credit to those who turned it in by original deadline. |