Course Schedule

This course schedule is tentative and might change as the semester progresses. The textbook refers to the “cow book” (see the syllabus).

Lecture slides and notes will be uploaded here before each class. The slides are designed to act only as an aid to the lectures, and not a replacement. Furthermore, the lectures themselves might often deviate significantly from the textbook in the order, presentation, and actual content. Thus, attending all lectures, including the discussion section lectures, is mandatory.

Module	Date	Topic	References	Slides	Activities
	W 9/5	Introduction	Ch 1
A1	M 9/10	SQL: Basics	Ch 5.1-5.3
A1	W 9/12	SQL: Basics	Ch 5.1-5.3
A1	M 9/17	Advanced SQL I	Ch 5.4
A1	W 9/19	Advanced SQL II	Ch 5.5, 5.6
A1	F 9/21	Discussion on SQL
A2	M 9/24	ER Model	Ch 2
A2	W 9/26	Functional Dependencies	Ch 19.1-19.3
A2	M 10/1	Functional Dependencies
A2	W 10/3	Decomposition & Normalization
A2	M 10/8	Decomposition & Normalization
A3	W 10/10	Relational Algebra	Ch 4.1,4.2
A3	M 10/15	Relational Alebra
B1	W 10/17	Data Storage & Buffer Management
B1	F 10/19	File Organization	Ch 9.5 -9.7
	M 10/22	Review
	W 10/24	MIDTERM
B2	M 10/29	Indexing	Ch 8
B2	W 10/31	Hashing	Ch 11.1, 11.2
B2	M 11/5	B+ tree	Ch 10
B2	W 11/7	Bitmaps
B3	M 11/12	External Sorting	Ch 13
B3	W 11/14	Relational Operators I	Ch 12.1-12.3, 14
B3	M 11/19	Relational Operators I & II	Ch 12.1-12.3, 14
B3	W 11/21	Relational Operators II	Ch 12.1-12.3, 14
B3	M 11/26	Query Optimization	Ch 12.4 - 12.6, 15.2, 15.3
B3	W 11/28	Query Optimization	Ch 12.4 - 12.6, 15.2, 15.3
B4	M 12/3	Transaction Management I	Ch 16
B4	W 12/5	Transaction Management II	Ch 16
	M 12/10	Advanced Topics
	W 12/12	Review
	S 12/19	FINAL EXAM