| Lecture # | Date | Topic | Reading | Assignments Etc | |
| 1 | Jan 4 | Introduction | Ch.1 | ||
| Discussion | Jan 6 | Java Tutorial | |||
| 2 | Jan 9 | ER Model | Ch.2 | Homework 1 Out | |
| 3 | Jan 11 | Relational Model | Ch. 3 | ||
| Discussion | Jan 13 | Project 1 Intro | Project 1 Assigned; Group Registration Due | ||
| Jan 16 | No Class | MLK Day | |||
| 4 | Jan 18 | ER to Relational | Ch. 3 | ||
| Discussion | Jan 20 | HW 1 Soln; Project 1 issues | Homework 1 Due | ||
| 5 | Jan 23 | Relational Algebra | Ch. 4 | ||
| 6 | Jan 25 | Relational Algebra (contd.) + Relational Calculus | Ch. 4 | Homework 2 Out | |
| Jan 26 | Project 1 Due at midnight | ||||
| Discussion | Jan 27 | JDBC and Project 2 discussion | Project 2 Assigned | ||
| 7 | Jan 30 | SQL | Ch. 5 | ||
| 8 | Feb 1 | SQL (contd.) and Triggers | Ch. 5 | ||
| Discussion | Feb 3 | HW 2 solutions | Read SQL Handout | HW 2 due | |
| 9 | Feb 6 | Database Application Pogramming | Ch 6, except 6.4 and 6.5 | ||
| 10 | Feb 8 | Normalization and Tuning | Ch. 19 except 19.8, and Ch. 20.7-20.9 | ||
| Feb 9 | Project 2 Due at midnight | ||||
| Discussion | Feb 10 | Exam Review | |||
| 11 | Feb 13 | Wrap up for First Half | |||
| Feb 15 | First Exam | ||||
| Discussion | Feb 17 | Minirel Overview | Project 3 Assigned | ||
| 13 | Feb 20 | Disks and Files | Ch. 9, except 9.2 | ||
| 14 | Feb 22 | Storage & Indexing | Ch. 8 | Homework 3 Out | |
| Discussion | Feb 24 | Exam solutions | |||
| Feb 27 -- Mar 2 | Midterm break | 15 | Mar 5 | Tree-Structured Indexing | Ch. 10, except 10.8.1 |
| 16 | Mar 7 | Hash-based Indexing | Ch. 11 | ||
| Discussion | Mar 9 | HW 3 Solutions | Homework 3 Due | ||
| 17 | Mar 12 | Sorting | Ch. 13 | ||
| 18 | Mar 14 | Storage & Indexing (contd.) | Ch. 8 | Homework 4 Out | |
| Mar 15 | Project 3 Due at midnight | ||||
| Discussion | Mar 16 | Project 4 intro and page counting | Project 4 Assigned | ||
| 19 | Mar 19 | Query Evaluation | Ch. 12, Ch. 14 | ||
| 20 | Mar 21 | Query Evaluation | |||
| Discussion | Mar 23 | HW 4 Solutions | Homework 4 Due | ||
| 21 | Mar 26 | Query Optimization | Ch. 15 | Homework 5 Out | |
| 22 | Mar 28 | Transactions | Ch. 16, except 16.6; Ch. 17, up to and including 17.4 | ||
| Mar 29 | Project 4 Due at midnight | ||||
| Discussion | Mar 30 | Review of counting page accesses | |||
| 23 | Apr 2 | Transactions (contd.) | Ch. 18, except 18.6 and 18.8 | ||
| 24 | Apr 4 | Transactions (contd.) | |||
| Discussion | Apr 6 | HW 5 Solutions | Homework 5 Due | ||
| 25 | Apr 9 | Open Topics | |||
| 26 | Apr 11 | Wrap up | |||
| Discussion | Apr 13 | Review | |||
| Apr 16 | Second Exam |