| WEEK | DAY | ANNOUNCEMENTS | READING | HW |
|---|---|---|---|---|
| 1 | Oct 05 | Last Day for P/NP, CR/NE, or Withdraw (Dec 06) |
Introduction and course overview (CH 1) | HW 0 (source: hw-0.tex) |
| Oct 07 | Relational model and relational algebra (CH. 2 - 2.4) | |||
| 2 | Oct 12 | Last Day to Add/Drop (Oct 13) | Relational model and relational algebra (CH. 2.5 to end) | HW 1 (source: 21f-hw-1.tex) |
| Oct 14 | SQL (CH. 3 - 3.5) | |||
| 3 | Oct 19 | SQL (CH. 3.6 - end) | ||
| Oct 21 | SQL (CH. 4 - 4.3) | HW 2 (source: 21f-hw-2.tex) | ||
| 4 | Oct 26 | SQL (CH. 4.4 - end) | ||
| Oct 28 | Database design and theory (CH. 6 - 6.5) | |||
| 5 | Nov 02 | Database design and theory (CH. 6.6 - end) | ||
| Nov 04 | ||||
| 6 | Nov 09 | Normalization (CH. 7 - 7.5) | ||
| Nov 11 | Normalization (CH. 7.5 - end) | HW 3 | ||
| 7 | Nov 16 | Applications (CH. 5.1) | ||
| Nov 18 | Project Presentations | |||
| Nov 23 | Thanksgiving Break (Nov 23-26) | |||
| Nov 25 | ||||
| 8 | Nov 30 | HTML, CSS | ||
| Dec 02 | PHP and ODBC | |||
| 9 | Dec 07 | Data Storage (CH. 12) | ||
| Dec 09 | No class (out sick) | |||
| 10 | Dec 14 | Indexing (CH. 13.1 - 13.3, 14.1-14.3) | ||
| Dec 16 | ||||
| 11 | Dec 21 | No class (COVID) | ||
| Dec 23 | Winter Break (Dec 23-Jan 02) | |||
| Dec 28 | ||||
| Dec 30 | ||||
| 12 | Jan 04 | Transactions (CH. 17) | ||
| Jan 06 | ||||
| 13 | Jan 11 | Concurrency (CH. 18) | ||
| Jan 13 | Final projects due by 2PM (Jan 19) | |||