Date	Chapter	Topic	Remarks
27-Aug	1	Introduction
30-Aug	2	The Entity-Relationship Model
1-Sep	2	The Entity-Relationship Model
3-Sep	3	The Relational Model
6-Sep	3	The Relational Model
8-Sep	4	Relational Algebra
10-Sep	4	Relational Calculus
13-Sep	5	SQL	Handout Assignment 2, Assignment 1 due at 2pm
15-Sep	5	SQL
17-Sep	5	SQL	Last Day to Add Courses
20-Sep	Discussion/Q&A		Yom Kippur
22-Sep	6	QBE
23-Sep			Assignment 2 due, 6pm
24-Sep	7	Disks and Files
27-Sep	7	Disks and Files
29-Sep	8	File Organization and Indexes
1-Oct	8	File Organization and Indexes
4-Oct	9	Tree-Structured Indexes
5-Oct	First Prelim	Chapters 1-7	Phillips 203
6-Oct	9	Tree-Structured Indexes
8-Oct	Discussion/Q&A		Johannes out of town
11-Oct	no class		Fall Break: 10/9-10/12
13-Oct	10	Hash-Based Indexes
15-Oct	11	External Sorting	Last Day to Drop Courses
18-Oct	12	Evaluation of Relational Operators	Assignment 3 due, 2pm
20-Oct	12	Evaluation of Relational Operators
22-Oct	12	Evaluation of Relational Operators
25-Oct	13	Introduction to Query Optimization
27-Oct	14	A Typical Relational Query Optimizer
29-Oct	14	A Typical Relational Query Optimizer
1-Nov	15	Schema Refinement and Normal Forms
3-Nov	15	Schema Refinement and Normal Forms
5-Nov	15	Schema Refinement and Normal Forms	Assignment 4 due, 2pm
8-Nov	16	Physical Database Design and Tuning
10-Nov	16	Physical Database Design and Tuning	Assignment 5 due in class
11-Nov	Second Prelim	Chapters 8-16	Phillips 101
12-Nov	18	Transaction Management Overview
15-Nov	18	Transaction Management Overview
17-Nov	19	Concurrency Control
19-Nov	20	Concurrency Control/Crash Recovery	Assignment 6 due, 2pm
22-Nov	20	Concurrency Control/Crash Recovery
24-Nov	no class		Thanksgiving break:
26-Nov	no class		Thanksgiving break:
29-Nov	20	Concurrency Control/Crash Recovery
1-Dec	17	Security
3-Dec	21	Parallel Databases	Assignment 7 due, 2pm
12-Oct	Final Exam	Chapters 1-21 with slight emphasis on chapters 17-24	Olin 155, 9am-11:30am