Page last updated: November 10, 1999

Topics and Readings

All these reading assignments are from the Ramakrishnan textbook. You are expected to have read the material before the class meeting (except for the first class). You are responsible for all material covered and all announcements made in class. Additional readings may be assigned for some topics. If so, you will get plenty of notice and will be given easy access to these readings.

Week	Topics	Readings

September 27	Introduction and the E/R model	1; 2.0.0 - 2.4.3; 2.5.0 - 2.5.2; 2.7
October 4	Relations and Logical Database Design	3.0.0 - 3.5.5; 3.6 - 3.8; 15.1 - 15.7; 15.9
October 11	Relational Query Languages	4.0.0 - 4.3.1; 4.5; 5.0 - 5.6; 5.11 - 5.14
October 18	Data Storage	7.0 - 7.5; 7.8; 8; 9.0 - 9.5; 9.9; 10.0 - 10.1
October 25	Query Processing	12.0 - 12.2; 12.4.0 - 12.4.3; 12.5.0 - 12.5.2; 12.8; 12.9; 13; 14.0.0 - 14.3.4; 14.7
November 1	Catch-Up; Physical Database Design	16.0 - 16.5; 16.7; 16.12
November 8	Concurrency Control and Recovery	18; 19.0.0 - 19.3.1; 19.4; 19.6; 20
November 15	Compression; Views	9.8.1; this paper; 3.6 (re-read); 23.5
November 22(*)	Object Database Design	25.0 - 25.6
November 29	Object Database Design and Queries	25.7 - 25.10
December 6	Catch-Up; Review; Exam	none

(*) NO CLASS Wednesday, November 24.