| Date | Topic | Reading |
|---|
| 9/22 | Intro, E/R model | 1, 2.2,3,2.4.3-4 |
| 9/27 | More E/R | 2.5 except 2.5.2, 2.6 | |
| 9/29 | Network, hierarchical, relational models | 2.7,
3.1-3 |
| 10/4 | Subclasses, Functional dependencies, Boyce-Codd
Normal Form
| 3.5-3.7.3 |
| 10/6 | Decomposition, Relational Algebra | 3.7.4-6,
4.1 |
| 10/11 | SQL queries | 5.1-3 |
| 10/13 | Bags, Duplicates, Aggregation, Modifications | 4.6, 5.4-6 |
| 10/18 | Schemas, Views | 5.7-8 |
| 10/20 | Nulls, Outerjoin, Constraints | 5.9, 6.1-3 |
| 10/25 | More constraints, Triggers | 6.4-6,
or-plsql.html |
| 10/27 | PL/SQL; Embedded SQL | 7.1 |
| 11/1 | Midterm Examination (tentative) | up to 10/27 lecture |
| 11/3 | Object-relational database systems | 8.5-6,
or-objects.html |
| 11/8 | More O-R, Return to normalization, 3NF | 3.7.7 |
| 11/10 | More 3NF, Multivalued dependencies and 4NF | 3.8 |
| 11/15 | Datalog | 4.2-3 |
| 11/17 | Recursion in SQL3 and Datalog | 4.4, 5.10 |
| 11/22 | OO design using ODL | 2.1, 2.4.1, 2.5.2,
3.2 |
| 11/24 | OO queries using OQL | 8.1-3 |
| 11/29 | More OQL | 8.4 |
| 12/1 | Querying XML data | Notes |
