Class Schedule

Week	Topic	Before Class	In Class	After Class
1	Introduction		Syllabus | Slides	HW1: Querying Large Files
1	Worlds of Database Systems		Slides | Exercise 1	Install DBMS Software
2	Worlds of Database Systems
2	Worlds of Database Systems			Slides | Exercise 3
3	The relational model of data		Slides | Exercise 2
3	Algebraic and logical query languages		Slides | Exercise 4
4	Algebraic and logical query languages		Slides | Exercise 5
4	SQL		Slides | Exercise 6	HW2: SQL
5	SQL		Slides | Exercise 7
5	SQL		Slides | Exercise 8
6	SQL in a server environment		Slides | Exercise 9
6	SQL in a server environment		Slides	HW3: Web App
7	Midterm Review	Ch.1 | 2 | 5 | 6	Mock Midterm
7	Midterm
8	SQL in a server environment	Ch.9	JDBC & JSF | JDBC example	Project
8	High-level database models		Slides | Exercise 10	HW4: ERD
9	Design theory for relational databases		Slides | Exercise 11
9	Design theory for relational databases		Slides | Exercise 12
10	Design theory for relational databases		Slides | Exercise 13
10	Constraints, triggers, view, indexes		Slides | Exercise 14
11	Transaction processing		Slides | Exercise 15
11	Transaction processing		Exercise 15
12	Transaction processing	Ch.17.1.Ch.18.0-2	Slides | Exercise 16
12	Storage and indexing		Slides | Exercise 17
13	TBD
13	Storage and indexing		Slides | Exercise 18
14	Query processing		Slides | Exercise 19
14	TBD
15	Semi-structured data and XML		Slides | Exercise 20
15	Final Exam Review		Mock Final
16	Project
16	Project