| Date | Topic | Reading |
|---|
| 9/24 | Intro, E/R model | 1, 2.2 |
| 9/29 | More E/R, ODL | 2.1, 2.4 |
| 10/1 | Weak entity sets, keys, subclasses | 2.5, 2.6
|
| 10/6 | Design principles, Network, hierarchical model | 2.3, 2.7 |
| 10/8 | Relational model
| 3.1-3 |
| 10/13 | Subclasses, Functional Dependencies | 3.4-6 |
| 10/15 | Normalization | 3.7 |
| 10/20 | Relational Algebra | 4.1 |
| 10/22 | SQL queries | 5.1-3 |
| 10/27 | Bags, duplicates, Aggregation, Modifications | 4.6, 5.4-6 |
| 10/29 | Schemas, Views, Nulls, Outerjoins | 5.7-9 |
| 11/3 | Midterm Examination | up to 10/27 lecture |
| 11/5 | Constraints, Triggers | 6.1-6 |
| 11/10 | PL/SQL | or-plsql.html |
| 11/12 | Embedded SQL, return to normalization | 7.1 |
| 11/17 | 3NF, MVD's, 4NF | 3.7-8 |
| 11/19 | Datalog | 4.2-3 |
| 11/24 | Recursion in SQL3 and Datalog | 4.4, 5.10 |
| 11/26 | OQL | 8.1-2 |
| 12/1 | More OQL | 8.3-4 |
| 12/3 | SQL3 Objects | 8.5-6 |
