| Day of Term | Day of Week | Date | Topics | Readings to be done in advance of this class |
| 1 | Wedneday | 1/4 | Warmup Assignment Given Introduction to course Introduction to databases |
Chapter 1 |
| 2 | Friday | 1/6 | Storing data: Disks and Files | Chapter 9 |
| 3 | Monday | 1/9 |
Warmup Assignment Due |
Chapter 9 |
| 4 | Wednesday | 1/11 | Storing data: Disks and Files Database Design and Entity-Relationship Model |
Chapter 9 Chapter 2 |
| 5 | Friday | 1/13 |
Database Design and Entity-Relationship Model |
Chapter 2 Chapter 3 |
| 6 | Monday | 1/16 | Relational Model Relational Algebra, Relational Calculus |
Chapter 3 Chapter 4 |
| 7 | Wednesday | 1/18 |
Relational Algebra, Relational Calculus |
Chapter 4 |
| 8 | Friday | 1/20 |
Relational Algebra, Relational Calculus |
Chapter 4 Chapter 5 |
| 9 | Monday | 1/23 |
SQL | Chapter 5 |
| 10 | Wednesday | 1/25 | Storage and Indexing Written Homework 1 Due |
Chapter 8 |
| 11 | Friday | 1/27 |
Storage and Indexing |
Chapter 8 |
| 12 | Monday | 1/30 | Storage and Indexing Tree Structured Indexing |
Chapter 8 Chapter 10 |
| 13 | Wednesday | 2/1 |
Tree Structured Indexing Minibase Assignment 2 Due |
Chapter 10 |
| 14 | Friday | 2/3 | Hash Based Indexing | Chapter 11 |
| Monday | 2/6 |
BREAK |
||
| 15 | Wednesday | 2/8 | Take Home Exam 1 Due PostgreSQL Assignment Given Hash Based Indexing Overview of Query Evaluation |
Chapter 11 Chapter 12 |
| 16 | Friday | 2/10 | Overview of Query Evaluation External Sorting |
Chapter 12 Chapter 13 |
| 17 | Monday | 2/13 |
External Sorting |
Chapter 13 Chapter 14 |
| 18 | Wednesday | 2/15 | PostgreSQL Assignment Due Minibase Assignment 3 Given Evaluation of Relational Operators |
Chapter 14 |
| 19 | Friday | 2/17 |
Evaluation of Relational Operators |
Chapter 14 |
| 20 | Monday | 2/20 |
Query Optimization |
Chapter 15 |
| 21 | Wednesday | 2/22 | Minibase Assignment 3 Due Written Homework 2 Given Minibase Assignment 4 Given Query Optimization |
Chapter 15 |
| 22 | Friday | 2/24 |
Query Optimization |
|
| 23 | Monday | 2/27 |
Schema Refinement and Normal Forms |
Chapter 19 |
| 24 | Wednesday | 3/1 |
Written Homework 2 Due |
Chapter 19 |
| 25 | Friday | 3/3 | Transaction Management |
Chapter 16 |
| 26 | Monday | 3/6 | Transaction Management |
Chapter 16 |
| 27 | Wednesday | 3/8 | Minibase Assignment 4 Due Object Database Systems |
Chapter 23 |
| 28 | Friday | 3/10 |
Take Home Exam 2 Assigned |
|
| Last Day of Finals | Take Home Exam 2 Due |