|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/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/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.
|2/20||Linux, PostgreSQL, HTML, PHP|
|3/6||(Prof out of town)|
|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
|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/24||Presentations and wrapup||XPath
Group project deliverables