| Week | Dates | Topics | Slides | Readings | Assignments |
|---|---|---|---|---|---|
| 1 | 3/26-3/30 | Introduction, Entity-Relationship model and design | M W F | 1, 2 | Practice Problems |
| 2 | 4/2-4/6 | Relational model, Functional and multivalued dependencies, Normal forms | M W F | 3 | HW1 |
| 3 | 4/9-4/13 | Relational algebra, SQL: Simple queries | M W F | 5, 6.1-6.2 | HW2 |
| 4 | 4/16-4/20 | SQL: Subqueries, Aggregation, Modifications, Schemas, Views | MW F | 6.3-6.7 | HW3 |
| 5 | 4/23-4/27 | Constraints, Triggers, Persistent stored modules | MW F | 7, 8.1-8.2, Notes | |
| 6 | 4/30-5/4 | Midterm Exam, Database connectivity, Transactions, Authorization | F | 8.3-8.7, Notes | HW4 |
| 7 | 5/7-5/11 | Indexing, Datalog | M W+F | 6.6.5, 6.6.6, Notes, 10.1-10.3 | HW5 |
| 8 | 5/24-5/18 | Data warehousing, Data mining | M+W F | Notes | HW6 |
| 9 | 5/21-5/25 | Semistructured data, XML, XPath, XQuery | M+W F | 4.6-4.7, Notes | HW7 |
| 10 | 5/30 | Review |