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