COMP 5120/6120: Database Systems I - Fall 2011

Week	Topics	Handouts	Reading
^1Aug. 14 – 20	Course Introduction	Intro
^2Aug. 21 – 27	Database System Overview Database Design	Lecture 1 Lecture 2 Project Intro	Chapter 1 Chapter 2
^3Aug. 28 – Sep. 3	ER Model Relational Model	Lecture 3 Lecture 4	Chapter 3
^4Sep. 4 – 10	Relational Model Relational Model	Lecture 5 Homework 0 Lecture 6
^5Sep. 11 – 17	Relational Algebra Relational Algebra	Lecture 7 Lecture 8 Homework 1	Chapter 4
^6Sep. 18 – 24	SQL Overview SQL Queries	Lecture 9 Lecture 10	Chapter 5
^7Sep. 25 – Oct. 1	Term Project Introduction No Class (IEEE Cluster 2011)	Term Project Homework 2
^8Oct. 2 – 8	SQL Queries Integrity Constraints in SQL	Lecture 11 Lecture 12
^9Oct. 9 – 15	SQL Triggers and Views Exam 1 Oct 13, 3:30 pm - 4:45 pm	Lecture 13
^10Oct. 16 – 22	Storage and Indexing Storage and Indexing	Lecture 14 Lecture 15	Chapter 8
^11Oct. 23 – 29	Storage and Indexing Disks and Files	Lecture 16 Lecture 17	Chapter 9
^12Oct. 30 – Nov. 5	Term Project Q&A No class (ACM GIS 2011)	Homework 3
^13Nov. 6 – 12	Disks and Files Tree-Structured Indexing	Lecture 18 Lecture 19	Chapter 10
^14Nov. 13 – 19	Tree-Structured Indexing Hash-Based Indexing	Lecture 20 Lecture 21	Chapter 11
^15Nov. 20 – 26	Thanksgiving Break
^16Nov. 27 – Dec. 2	Hash-Based Indexing Exam 2 Dec 1, 3:30 pm - 4:45 pm	Lecture 22
	Term Project Due Dec 6 @ 11:59 pm