| Date | Topic | Reading |
|---|
| 9/27 | Intro, E/R model | 1, 2.1, 2.3 |
| 10/2 | Weak enitity sets, E/R design | 2.2, 2.4 | |
| 10/4 | Relational model, Functional Dependencies | 3.1-3.5 |
| 10/9 | Normal forms, Multivalued dependencies | 3.6-3.7 |
| 10/11 | Relational Algebra | 5
|
| 10/16 | SQL queries | 6.1, 6.2 |
| 10/18 | Subqueries, Grouping/aggregation, | 6.3,
6.4 |
| 10/23 | Modifications, Schemas, Views | 6.5-6.7 |
| 10/25 | Constraints | 7.1-7.3, 7.4.1 |
| 10/30 | Triggers, PL/SQL | 7.4, 8.2,
or-plsql.html |
| 11/1 | More PL/SQL, Embedded SQL, CLI, JDBC | 8.1,
8.3-8.5,
or-jdbc.html,
|
| 11/6 | Midterm Examination | up to 11/1 lecture |
| 11/8 | Object-relational
systems | 4.5, 9.4, 9.5,
or-objects.html
|
| 11/13 | More O-R, Transactions, Authorization | 8.6,
8.7 |
| 11/15 | Datalog | 10.1, 10.2 |
| 11/20 | Datalog and SQL recursion, ODL | 10.3, 10.4,
4.1-4.4 |
| 11/27 | More ODL, OQL | 9.1
|
| 11/29 | More OQL | 9.2, 9.3 |
| 12/4 | Semistructured data, XML, Xquery | 4.6, 4.7,
Notes |
| 12/6 | Data warehouses, Data mining | Notes |
