| Date | Topic | Required Reading | Materials | Assignments Out | Slides |
|---|---|---|---|---|---|
| 8/22 | Introduction | All of chapter 1 | First day survey | slides | |
| 8/27 | Data models | 2.1, 2.2 | slides | ||
| 8/29 | Relational algebra | 2.4 | Project Milestone 1, due at the start of class on Thu 9/12 | slides | |
| 9/3 | More relational algebra, start SQL | 6.1 | Homework 1, due at the start of class on Tue 9/10 | (see previous slides) | |
| 9/5 | SQL joins | 6.2 | (no slides) | ||
| 9/10 | SQL subqueries, started grouping & aggregation | 6.3 | (no slides) | ||
| 9/12 | SQL grouping and aggregation | 6.4 | (no slides) | ||
| 9/17 | SQL create, update | (no slides) | |||
| 9/19 | E/R modeling | 4.1 | Homework 2, due at the start of class on Thu 9/26 | slides | |
| 9/24 | E/R modeling II | 4.1-4.3 | (see slides above) | ||
| 9/26 | E/R modeling III | 4.4-4.5 | (see slides above) | ||
| 10/1 | E/R modeling IV | 4.6 | Homework 3, due in class on 10/10 Project Milestone 2, due in class on 10/24 |
(see slides above) | |
| 10/3 | HTML lab | lab | (no slides) | ||
| 10/8 | Flask lab I | lab | (no slides) | ||
| 10/10 | Flask lab II | lab | (no slides) | ||
| 10/15 | Fall break | ||||
| 10/17 | Midterm review | ||||
| 10/22 | Midterm | ||||
| 10/24 | Functional dependencies I | 3.1 | handout | slides | |
| 10/29 | (Class canceled) | ||||
| 10/31 | Functional dependencies II | 3.2 | Project Milestone 3, due on Moodle at 5:00 pm on 11/7 | (see slides above) | |
| 11/5 | BCNF/Normalization | 3.3 | handout | slides | |
| 11/7 | 3NF/Multivalued dependencies/4NF | 3.5, 3.6 | Homework 4, due in class on 11/14 | (see slides above) | |
| 11/12 | Indices, B-Trees | 8.3, plus B-tree handouts | B-tree overview and insertion B-tree deletion |
slides | |
| 11/14 | Query optimization | Query opt is not in the textbook; refer to slides | slides | ||
| 11/19 | Transactions | 6.6, plus slide material not in book | Homework 5 (use for practice) | slides | |
| 11/21 | NoSQL | slides | |||
| 11/26 | NoSQL | lab | |||
| 12/3 | Group presentations | slides |