| Week | Date | Topic | Reading |
|---|---|---|---|
| 1 | 9/25 | Class introduction, Entity-Relationship model | Chapters 1, 2.2 |
| 1 | 9/27 | Entity-Relationship design | Chapters 2.3-2.6 (skip ODL stuff) |
| 2 | 10/2 | Relational model, Functional dependencies | Chapters 3.1, 3.3, 3.5, 3.6 |
| 2 | 10/4 | Multivalued dependencies, Normal forms | Chapters 3.7, 3.8 |
| 3 | 10/9 | Relational algebra | Chapter 4 (skip Datalog stuff - 4.3, 4.4) |
| 3 | 10/11 | SQL queries | Chapters 5.1, 5.2 |
| 4 | 10/16 | Subqueries, Aggregation | Chapters 5.3-5.5 |
| 4 | 10/18 | Modifications, Schemas, Views | Chapters 5.6-5.8 |
| 5 | 10/23 | Constraints | Chapters 6.1-6.5 |
| 5 | 10/25 | Triggers, PL/SQL | Chapters 6.6, 7.1 |
| 6 | 10/30 | More PL/SQL, Embedded SQL | Chapter 7.3 |
| 6 | 11/1 | Midterm | Covers all lectures up to and including 10/30 |
| 7 | 11/6 | Transactions, Authorization | Chapters 7.2, 7.4 |
| 7 | 11/8 | Datalog | Chapter 4.3 |
| 8 | 11/13 | Datalog and recursion | Chapters 4.4, 5.10 |
| 8 | 11/15 | Object-relational model, ODL, OQL | Chapters 8.1, 8.2 |
| 9 | 11/20 | More OQL | Chapters 8.3, 8.4 |
| 9 | 11/22 | No class | Happy Thanksgiving! |
| 10 | 11/27 | Data mining | Notes |
| 10 | 11/29 | Review Session | Everything you always wanted to now about DB but were afraid to ask |