| Week of | Monday | Wednesday | Friday |
| September 27 | Introduction Chapter 1 |
ODL Section 2.1 |
E/R diagrams Section 2.2 |
| October 4 | Principles of Design 2.3, 2.4 (except 2.4.1 and 2.4.2) |
Constraints 2.5(3-7), 2.6) |
Relational Model 3.1 Homework 1 due Project groups decided |
| October 11 | Going from E/R to relations 3.3,3.4(3.2 is recommended) |
Normalization 3.5-3.7.7 |
Normalization cont. |
| October 18 | Relational algebra 4.1,4.6 (except 4.6.7) Preliminary Project proposals due |
SQL 5.1-5.9 Homework 2 due |
SQL |
| October 25 | SQL Project E/R diagrams and schemas due |
SQL cont. | Recursion and Datalog 4.2-4.4,5.10 Homework 3 due |
| November 1 | Midterm | Constraints in SQL 6.1-6.4(rest of 6 recommended) |
Systems aspects 7:7.1,7.2 Project formal specifications due |
| November 8 | SQL3 8.5-8.6 Homework 4 due |
DBMS system overview Book 2: 1.1,1.2,1.3,2.1 |
Indexing Chapter 4 |
| November 15 | Indexing continued |
Query Execution 6.1 is a review (gets interesting towards end) read 6.1 through 6.10 (but not 6.5.3-4, 6.6.4) |
Query Execution/Optimization
Skim 7.1 Read 7.2.1, 7.3-7.7 (but not 7.6.6) Project sample end-to-end application due |
| November 22 | Optimization Homework 5 due |
Optimization cont. | Thanksgiving Vacation |
| November 29 | Recovery
Chapter 8 |
Recovery and transaction processing cont. Homework 6 due |
Recovery and transaction processing cont. |
| December 6 | XML External readings |
Data Integration | FINAL EXAM |