Schedule

Date		Topic	Reading	Due
08.27	Thu	Intro to Databases Relational Model	Relational Fundamentals
09.01	Tue	SQL Basics Quiz 1	SQL Tutorial - Basics
09.03	Thu	SQL Joins	SQL Tutorial - Aggregate Calculations	SQL Ex 1
09.08	Tue	Quiz 2 SQL Set Operations	SQL Tutorial - Joins
09.10	Thu	SQL Self Joins SQL Conditional Logic SQL Null Values Test 1 Review	SQL Tutorial - Nested Queries; SQL Tutorial - Miscellaneous	SQL Ex 2
09.15	Tue	Test 1
09.17	Thu	E-R Modeling I	Database Design Ch. 2
09.22	Tue	E-R Modeling II		Model Ex 1
09.24	Thu	E-R Database Models
09.29	Tue	Inheritance SQL DML		Model Ex 2
10.01	Thu	Test 2
10.06	Tue	Database Development	MySQL and MS Access
10.08	Thu	Modeling Tips		Lab 1
10.13	Tue	Project Intro Normal Forms		Lab 2
10.15	Thu	Project Discussion Normal Forms, cont.		Project Draft ER Model
10.20	Tue	Fall Break (No Class)
10.22	Thu	Normal Forms, cont. Denormalization		Project Final ER Model
10.27	Tue	Data Integrity Database Programming
10.29	Thu	Database Programming		Project DB Implementation
11.03	Tue	Database Programming Test 2 Review
11.05	Thu	Test 3
11.10	Tue	TBA
11.12	Thu	TBA
11.17	Tue	Transactions		Project App Dev 1
11.19	Thu	Transactions, cont.	Transactions	Lab 4
11.24	Tue	Thanksgiving Break (No Class)
11.26	Thu	Thanksgiving Break (No Class)
12.01	Tue	Disaster Recovery
12.03	Thu	MySQL Disaster Recovery
12.08	Tue	Data Privacy Data Security		Project App Dev 2
12.10	Thu	Indexing Final Review		Lab 5