| Date | Topic | Reading | Lecturer |
|---|
| 9/25 | The E/R model | Ch. 2 | Ullman |
| 9/30 | E/R design exercise and examples | -
| Rajaraman |
| 10/2 | Relational model, Functional Dependencies | 3.1--3.5 | Ullman |
| 10/7 | Normalization, Multivalued dependencies | 3.6, 3.7 | Ullman |
| 10/9 | Relational Algebra | 5
| Rajaraman |
| 10/14 | SQL queries | 6.1--6.3 | Rajaraman |
| 10/16 | SQL queries and data-definition | 6.4--6.7 | Rajaraman |
| 10/21 | Constraints and Triggers | Ch. 7, or-triggers.html | Rajaraman |
| 10/23 | PSM and PL/SQL | 8.2,
or-plsql.html | Ullman |
| 10/28 | Embedded SQL, CLI, JDBC | 8.1,
8.3--8.5,
or-jdbc.html,
| Rajaraman |
| 10/30 | Object-relational
systems | 4.5, 9.4, 9.5,
or-objects.html
| Ullman |
| 11/4 | Midterm Examination | up to 10/30
lecture | - |
| 11/6 | Datalog | 10.1--10.3 | Rajaraman |
| 11/11 | SQL recursion | 10.4,
Notes | Rajaraman |
| 11/13 | Transactions, Authorization | 8.6,
8.7 | Rajaraman |
| 11/18 | Universal Modeling Language,
Object-Description Language | Notes, 4.1--4.4 | Ullman |
| 11/20 | Object-Oriented Databases:
OQL | 9.1--9.3 | Ullman |
| 11/25 | Semistructured data, XML | 4.6, 4.7,
Notes | Ullman |
| 12/2 | XPath, XQuery | Notes
| Chamberlin |
| 12/4 | XQuery |
Notes
| Chamberlin |
