Schedule

Date		Topic	Reading	Due
08.27	Thu	Intro to Databases Relational Model	Relational Fundamentals
09.01	Tue	SQL Basics	SQL By Example Ch. 2-3	SQL Tutorial 1
09.03	Thu	SQL Joins	SQL By Example Ch. 4, 7	SQL Ex 1 SQL Tutorial 2
09.08	Tue	Database Modeling	Database Design Ch. 2	Quiz 2
09.10	Thu	Business Database Modeling		SQL Ex 2
09.15	Tue	Implementing Models
09.17	Thu	More SQL		Model Ex 1
09.22	Tue	Conditional Logic Self-Referential Relationships	Case Expression	SQL Ex 3
09.24	Thu	Null Values Inheritance SQL DML Test 1 Review		Model Ex 2
09.29	Tue	Test 1
10.01	Thu	Views MySQL and MS Access
10.06	Tue	Database Development
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 2
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