Class Schedule

Week	Date	Topic	Before Class	In Class	After Class
1	Tue Aug 25	Introduction		Syllabus | Slides	HW1: Querying Large Files
1	Thu Aug 27	Worlds of Database Systems	Ch.1 | Quiz01	Slides | Exercise 1	Install DBMS Software
2	Tue Sep 1	No Class			Ch.2 | Quiz02
2	Thu Sep 3	No Class			Slides | Exercise 3
3	Tue Sep 8	The relational model of data	Ch.2 | Quiz03	Slides | Exercise 2
3	Thu Sep 10	Algebraic and logical query languages	Ch.5 | Quiz04	Slides | Exercise 4
4	Tue Sep 15	Algebraic and logical query languages	Ch.5 | Quiz05	Slides | Exercise 5
4	Thu Sep 17	SQL	Ch.6 | Quiz06	Slides | Exercise 6	HW2: SQL
5	Tue Sep 22	SQL	Ch.6 | Quiz07	Slides | Exercise 7
5	Thu Sep 24	SQL	Ch.6 | Quiz08	Slides | Exercise 8
6	Tue Sep 29	SQL in a server environment	Ch.9 | Quiz09	Slides | Exercise 9
6	Thu Oct 1	SQL in a server environment	Ch.9 | Quiz10	Slides	HW3: Web App
7	Tue Oct 6	Midterm Review	Ch.1 | 2 | 5 | 6	Mock Midterm
7	Thu Oct 8	Midterm
8	Tue Oct 13	SQL in a server environment	Ch.9	JDBC & JSF | JDBC example	Project
8	Thu Oct 15	High-level database models	Ch.4 | Quiz11	Slides | Exercise 10	HW4: ERD
9	Tue Oct 20	Design theory for relational databases	Ch.3 | Quiz12	Slides | Exercise 11
9	Thu Oct 22	Design theory for relational databases	Ch.3 | Quiz13	Slides | Exercise 12
10	Tue Oct 27	Design theory for relational databases	Ch.3 | Quiz14	Slides | Exercise 13
10	Thu Oct 29	Constraints, triggers, view, indexes	Ch.7-8 | Quiz15	Slides | Exercise 14
11	Tue Nov 3	Transaction processing	Ch.17.1.Ch.18.0-2 | Quiz16	Slides | Exercise 15
11	Thu Nov 5	Transaction processing	Ch.17.1.Ch.18.0-2 | Quiz17	Exercise 15
12	Tue Nov 10	Transaction processing	Ch.17.1.Ch.18.0-2	Slides | Exercise 16
12	Thu Nov 12	Storage and indexing	Ch.13.0-2.Ch.14.0-2 | Quiz18	Slides | Exercise 17
13	Tue Nov 17	Guest Lecture: Database Administration
13	Thu Nov 19	Storage and indexing	Ch.13.0-2.Ch.14.0-2 | Quiz19	Slides | Exercise 18
14	Tue Nov 24	Query processing	Ch.16.1.Ch.15.0-3 | Quiz20	Slides | Exercise 19
14	Thu Nov 26	Thanksgiving Holiday
15	Tue Dec 1	Semi-structured data and XML	Ch.11-12 | Quiz21	Slides | Exercise 20
15	Thu Dec 3	Final Exam Review		Mock Final
16	Tue Dec 8	Project
16	Thu Dec 10	Project