Database Systems

#	Date		Topic	Reading	Project	Practice Problems
1	9/5	W	Introduction and Overview
2	9/7	F	The Entity-Relation Model	Ch. 2	DB Proposal	ER Modeling
3	9/10	M	The Entity-Relation Model	Ch. 3	due: Fri 9/14
4	9/12	W	Relational Algebra	Ch. 4
5	9/14	F	Relational Algebra		ER Diagrams	Relational Algebra
6	9/17	M	Relational Calculus		due: Fri 9/21
7	9/19	W	SQL: Creating Tables	Ch. 5
8	9/21	F	SQL: Simple Queries		Relational Schemata/Queries	(skipped)
9	9/24	M	Lab #3 make-up: SQL + TRC		due: Fri 9/28
10	9/26	W	SQL: Aggregate Queries
11	9/28	F	SQL: Nested Queries			More SQL
12	10/1	M	SQL: Deletes, Updates, and Inserts
13	10/3	W	Review for Midterm #1
14	10/5	F	EXAM #1		Populate the DB
15	10/9	T	SQL: Views, Domains, Constraints		due: Fri 10/19
16	10/10	W	Database Apps on the Web	Ch. 7
17	10/12	F	Database Apps on the Web			HTML and Forms
18	10/15	M	Introduction to PHP	handouts
19	10/17	W	Introduction to PHP	handouts
20	10/19	F	Disks & Files: Intro	Ch. 8 & 9	Design Web Interface	PHP exercises
21	10/22	M	Disks & Files: The Buffer Manager		due: Mon 11/29
22	10/24	W	Disks & Files: Page/File Formats
23	10/26	F	Disks & Files: Files and Indexes			Paging Algorithms
	10/29	M	Class Cancelled (Hurricane)
24	10/31	W	Disk Redundancy	Ch. 9.2
25	11/2	F	Transaction Management	Ch. 16	Implement Web Interface	More Paging
26	11/5	M	Transactions and Schedules		due: Fri 12/7
27	11/7	W	Review for Midterm #2
28	11/9	F	EXAM #2
29	11/12	M	Transactions and Locking
30	11/14	W	Concurrency Control	Ch. 17
31	11/16	F	Concurrency Control		CHECKPOINT #1	Transactions
32	11/19	M	Concurrency Control
	11/21	W	THANKSGIVING
	11/23	F	BREAK
33	11/26	M	Concurrency Control
34	11/28	W	Concurrency Control
35	11/30	F	Crash Recovery	Ch. 18	CHECKPOINT #2	Concurrency
36	12/3	M	Security and Authorization	Ch. 21
37	12/5	W	Review for Final Exam
38	12/7	F	Review for Final Exam	FINAL: Wed December 12th, 11:30 am