| Date | Topic | Reading |
|---|
| 9/28 | The E/R Model | Ch. 2 |
| 9/30 | E/R Design, Intro. to Relational Model | 3.1--3.3
|
| 10/5 | Functional Dependencies | 3.4, 3.5 |
| 10/7 | Normalization, Multivalued Dependencies | 3.6, 3.7 |
| 10/12 | Relational Algebra | 5
|
| 10/14 | SQL Queries | 6.1--6.3 |
| 10/19 | SQL Queries and Data-definition | 6.4--6.7 |
| 10/21 | SQL: Views, Constraints | Ch. 7 up to 7.4.1
|
| 10/26 | SQL: Triggers, PSM | 7.4, 8.2,
or-triggers.html
|
| 10/28 | PL/SQL, Embedded SQL | 8.1,
8.3--8.5,
or-plsql.html |
| 11/2 | CLI, JDBC,
Object-Relational
Systems |
4.5, 8.3--8.5,
9.4, 9.5,
or-jdbc.html
|
or-objects.html
| 11/4 | Midterm Examination | up to PL/SQL
|
| 11/9 | More OR Systems, Semistructured Data | 4.6
|
| 11/11 | XML, XPath | 4.7, Notes |
| 11/16 |
XQuery | Notes |
| 11/18 | Transactions, Authorization | 8.6,
8.7 |
| 11/23 | Data warehouses, Data mining | Notes |
| 11/30 | Datalog | 10.1--10.3
|
| 12/2 | Object-Oriented Databases: ODL,
OQL | 4.1--4.4, 9.1--9.3 |
| 12/6 | Final Exam 3:30 - 6:30 | All except 11/30 and
12/2 |
