| Homework 1 | E/R diagrams | Due October 8 | Answers |
| Homework 2 | Functional Dependencies, XML | Due October 20 | Answers |
| Homework 3 | SQL | Due October 29 | Answers |
| Homework 4 | Interfacing with Java to SQL | Due November 8 | Answers |
| Homework 5 | Storage and Indexing | Due November 22 | Answers - Problem 1, Problems 2-5 |
| Homework 6 | Optimizations | Due December 4 | Answers |
| DATE | LECTURE | POWERPOINT | HTML | POSTSCRIPT |
|---|---|---|---|---|
| 09/25 | Introduction | |||
| 09/27 | Database Design | |||
| 09/29 | Database Design | |||
| 10/02 | The Relational Data Model | |||
| 10/04 | Functional Dependencies | |||
| 10/06 | Functional Dependencies | |||
| 10/09 | Normal Forms, Relational Algebra | |||
| 10/11 | XML Data | |||
| 10/13 | The Relational Algebra | |||
| 10/16 | Relational Algebra / Datalog | |||
| 10/18 | SQL | |||
| 10/20 | SQL | |||
| 10/23 | SQL | |||
| 10/25 | SQL | |||
| 10/27 | Querying XML | |||
| 10/30 | Midterm | |||
| 11/01 | System Aspects of SQL | |||
| 11/03 | Java, JDBC, Perl, CGI, Embedded SQL | |||
| 11/06 | DBMS Overview, Data Storage | |||
| 11/08 | Representing Data Elements | |||
| 11/13 | Indexes | |||
| 11/15 | Indexing continued... | |||
| 11/17 | Query Execution | |||
| 11/20 | Query Execution | |||
| 11/22 | Query Optimization | |||
| 11/27 | Cost-based Optimization | |||
| 11/29 | Optimizations | |||
| 12/1 | Recovery | |||
| 12/4 | Recovery | |||
| 12/6 | Final Review |
All grades are here.