Class Schedule

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