| Lecture # | Date | Day | Topic | Reading | Handout | Assignment Due |
| 1 | January 5 | Wednesday | Introduction [pdf] | Ch.1 | Homework 1 (Sample Solution) | |
| Discussion | January 7 | Friday | NO CLASS | |||
| 2 | January 10 | Monday | ER Model [pdf] | Ch.2 | Project 1 | |
| 3 | January 12 | Wednesday | Relational Model [pdf] | Ch. 3 | ||
| Discussion | January 14 | Friday | Project 1 Intro [pdf] | |||
| January 17 | Monday | MLK Day (NO CLASS) | ||||
| 4 | January 19 | Wednesday | ER-to-Relational [pdf] | Ch.3 | ||
| Discussion | January 21 | Friday | ER and Relational Examples | Homework 1 | ||
| 5 | January 24 | Monday | Relational Algebra [pdf] | Ch. 4.1,4.2 | Homework 2 (Sample Solution) | |
| 6 | January 26 | Wednesday | Relational Algebra [pdf] | Ch. 4.1,4.2 | Project 1 | |
| Discussion | January 28 | Friday | Project 2 Intro [pdf] | Project 2 | ||
| 7 | January 31 | Monday | Relational Calculus [pdf] | |||
| 8 | February 2 | Wednesday | SQL Queries [pdf] | Ch. 5 | Toby Teorey's Mini SQL User Guide | |
| Discussion | February 4 | Friday | (Relational Algebra and Calculus) | |||
| 9 | February 7 | Monday | SQL Queries (cont.) | Ch. 5 | ||
| 10 | February 9 | Wednesday | Database Application Programming, JDBC [pdf] | Ch. 6, Except 6.4 and 6.5 | ||
| Discussion | February 11 | Friday | (SQL Examples) | Homework 2 | ||
| 11 | February 14 | Monday | Normalization [pdf] | Ch. 19.1-19.7 | ||
| 12 | February 16 | Wednesday | Elements of Physical Database Design [pdf] | Ch. 8 | Project 2 | |
| Discussion | February 18 | Friday | ||||
| 13 | February 21 | Monday | Exam Review | |||
| February 23 | Wednesday | Exam (In Class) | ||||
| February 25-March 4 | Monday | Spring Break | ||||
| 14 | March 7 | Monday | Disks and Files [pdf, examples] | Ch. 8,9 | Homework 3 (Sample Solution)
Project 3 | |
| 15 | March 9 | Wednesday | Tree-Structured Indexing [pdf] | Ch. 10 | ||
| Discussion | March 11 | Friday | (Project 3 Intro) [pdf] | |||
| 16 | March 14 | Monday | Tree-Structured Indexing (cont.) | Ch. 10 | ||
| 17 | March 16 | Wednesday | Hash-based Indexing [pdf] | Ch. 11 | ||
| Discussion | March 18 | Friday | (Indexing Examples) | Homework 3 | ||
| 18 | March 21 | Monday | External Sorting [pdf] | Ch. 13 | ||
| 19 | March 23 | Wednesday | Query Evaluation [pdf] | Ch. 12, 14 | Project 3 | |
| Discussion | March 25 | Friday | (Project 4 Intro) [pdf] | Project 4 | ||
| 20 | March 28 | Monday | Query Evaluation (cont.) | Ch. 12, Ch. 14 | Homework 4 (Sample Solution) | |
| 21 | March 30 | Wednesday | Query Optimization [pdf] | Ch. 15 | ||
| Discussion | April 1 | Friday | (Query Evaluation and Sorting) | |||
| 22 | April 4 | Monday | Transactions [pdf] | Ch. 16, except 16.6 | ||
| 23 | April 6 | Wednesday | Concurrency Control [pdf] | Ch. 17, except 17.5, 17.6 | Locking Handout | |
| Discussion | April 8 | Friday | Homework 4 | |||
| 24 | April 11 | Monday | Recovery [pdf] | Ch. 18 | ||
| 25 | April 13 | Wednesday | Recovery (cont.) | Ch. 18 | Project 4 | |
| Discussion | April 15 | Friday | (Transactions and Recovery) | |||
| 26 | April 18 | Monday | Exam Review | Ch. 18 |