| WK | Class/Date | Topic | Book Chapter | Homeworks | Lecture Notes |
|---|---|---|---|---|---|
| 1 | Tue 2/1 | Introduction | Ch 1 |
Lecture 1 slides Chapter 2 and 3 slides |
|
| Thu 2/3 | Database Planning and the Entity-Relationship Model | Ch 2-3 | Project Part 1 assigned | ||
| 2 | Tue 2/8 | Project Part 2 assigned | |||
| Thu 2/10 | Relational Model : EER to Relational | Ch 4 | Project Part 1 due | Chapter 4 slides | |
| 3 | Tue 2/15 |
Meet in DBH 101! Masks on, daily screening form completed. Relational Model : Relational Algebra |
Hwk 1 assigned | ||
| Thu 2/17 | Part 2 Review 1 deadline | R.A. exercise | |||
| 4 | Tue 2/22 | Relational Algebra, and SQL, SQL, SQL | Ch 5 | Part 2 Review 2 deadline |
Chapter 5 slides, Part A R.A. exercise #2 |
| Thu 2/24 | Quiz | Project Part 2 due (Friday) | |||
| 5 | Tue 3/1 |
Hwk 1 due Project Part 3 assigned |
|||
| Thu 3/3 | Hwk 2 assigned | ||||
| 6 | Tue 3/8 | ||||
| Thu 3/10 | SQL (cont.), class exercise | ||||
| 7 | Tue 3/15 | and now some SQL -to- PL API | Chapter 5 slides, Part B | ||
| Thu 3/17 | |||||
| 8 | Tue 3/22 |
PHP... and Database Normalization |
Ch 6 | Project Part 3 due | Chapter 6 slides |
| Thu 3/24 |
Visiting speaker in class today! (Midterm moved to after Spring Break.) |
Hwk 2 due Mini-Homework assigned |
|||
| 9 | Tue 3/29 | School Holiday: Spring Break | |||
| Thu 3/31 | School Holiday: Cesar Chavez Day | ||||
| 10 | Tue 4/5 | Midterm |
Mini-Homework due Project Part 4 assigned |
||
| Thu 4/7 | |||||
| 11 | Tue 4/12 | Project Part 5 assigned | |||
| Thu 4/14 |
Transactions and Concurrency Control -- the secret sauce for scale-up Class via Zoom today, to save gas money |
Ch 9 | Project Part 4 due (old) | Chapter 9 slides | |
| 12 | Tue 4/19 |
Project Part 4 due (new) Hwk 3 assigned Project Part 6 assigned |
|||
| Thu 4/21 | Quiz | ||||
| 13 | Tue 4/26 | Recovery - ARIES | |||
| Thu 4/28 | Class via Zoom today, to save gas money | ||||
| 14 | Tue 5/3 | Relational Query Optimization | Ch 13 |
Project Part 5 due Hwk 3 due Project Part 7 assigned Hwk 4 assigned |
Chapter 13 slides ARIES Exercise slide |
| Thu 5/5 | Class via Zoom today, to save gas money | ||||
| 15 | Tue 5/10 | Project Part 6 due | Query Plan Exercise slide | ||
| Thu 5/12 | Database Security | Ch 8 | Chapter 8 slides | ||
| 16 | Tue 5/17 | Wrap-up the semester |
Wrap-Up slides Grant / Revoke Exercise slide |
||
| Thu 5/19 | First day of final exams | ||||
| 17 | Thursday 5/19 |
FINAL EXAM
Location: DBH 101 Time: 2 - 4 pm |
Hwk 4 due (5/17) Project Part 7 due (5 pm 5/25) |