| Date | Topic | Required Reading | Notes | Assignments Out | Slides |
| 1/9 | Intro, data models | all of chapter 1, 2.1 | slides | ||
| 1/14 | The relational model, relational algebra | 2.2, 2.4 | slides | ||
| 1/16 | More relational algebra, just started SQL | 2.4, 6.1 | |||
| 1/21 | SQL | 6.1, 6.2 | |||
| 1/23 | SQL: Subqueries | 6.3 | Project Milestone 1, due in class on February 6. Homework 1, due in class on January 30. |
||
| 1/28 | SQL: Aggregation and grouping | 6.4 | |||
| 1/30 | SQL: Creating/updating tables, constraints | 2.3, 6.5 | slides | ||
| 2/4 | SQL: More constraints | 2.5, 7.1-7.3 | Homework 2, due in class on February 13. | slides | |
| 2/6 | E/R modeling | 4.1 | slides | ||
| 2/11 | E/R modeling II | 4.1-4.3 | slides | ||
| 2/13 | E/R modeling III | 4.4, 4.5 | slides | ||
| 2/18 | E/R modeling IV | 4.5, 4.6 | Project Milestone 2, due in class on March 4. Homework 3, due in class on February 25. |
slides | |
| 2/20 | Linux, PostgreSQL, HTML, PHP | ||||
| 2/25 | PHP | ||||
| 2/27 | Midterm | ||||
| 3/4 | Programming | ||||
| 3/6 | (Prof out of town) | ||||
| 3/18 | Functional dependencies | 3.1 | slides | ||
| 3/20 | Functional dependencies | 3.2 | (see previous slides) | ||
| 3/25 | Normalization and BCNF | 3.3 | slides | ||
| 3/27 | 3NF and multivalued dependencies | 3.5, 3.6 | Homework 4, due in class on April 8. | slides | |
| 4/1 | Wrapup multivalued dependencies and 4NF | (see normalization slides) | |||
| 4/3 | Indexes and B-trees | 8.3, plus B-tree stuff (not in book) | B-tree data structure and insertion algorithm B-tree deletion algorithm |
slides | |
| 4/8 | Query optimization/Views | Query opt is not in the book; views is 8.1 | slides | ||
| 4/10 | Transactions | 6.6, plus slide material not in book | Homework 5, due in class on April 22. | slides | |
| 4/15 | XML | ||||
| 4/22 | XML | ||||
| 4/24 | Presentations and wrapup | XPath XPath problems Group project deliverables Self/group evaluation |
slides |