Schedule

Date		Topic	Reading	Due
08.28	Thu	Intro to Databases Relational Model	Relational Fundamentals
09.02	Tue	SQL Basics	SQL By Example Ch. 2-3	Quiz 1 Discussion 1
09.04	Thu	SQL Joins	SQL By Example Ch. 4, 7	SQL Ex 1
09.09	Tue	Database Modeling	Database Design Ch. 2	Quiz 2
09.11	Thu	Business Database Modeling		Discussion 2 SQL Ex 2
09.16	Tue	Implementing Models
09.18	Thu	More SQL		Model Ex 1
09.23	Tue	Conditional Logic Self-Referential Relationships	Case Expression	SQL Ex 3
09.25	Thu	Null Values Inheritance SQL DML Test 1 Review		Model Ex 2
09.30	Tue	Test 1
10.02	Thu	Views MySQL and MS Access
10.07	Tue	Database Development
10.09	Thu	Modeling Tips		Lab 1
10.14	Tue	Project Intro Normal Forms		Lab 2
10.16	Thu	Project Discussion Normal Forms, cont.		Project Draft ER Model
10.21	Tue	Fall Break (No Class)
10.23	Thu	Normal Forms, cont. Denormalization		Project Final ER Model
10.28	Tue	Data Integrity
10.30	Thu	Database Programming		Project DB Implementation
11.04	Tue	Database Programming Test 2 Review
11.06	Thu	Test 2
11.11	Tue	Procedural SQL	Stored Procedure Tutorial, Sections 1-2	Lab 3
11.13	Thu	Procedural SQL, cont.	Stored Procedure Tutorial, Sections 5-6
11.18	Tue	Transactions		Project App Dev 1
11.20	Thu	Transactions, cont.	Transactions	Lab 4
11.25	Tue	Thanksgiving Break (No Class)
11.27	Thu	Thanksgiving Break (No Class)
12.02	Tue	Disaster Recovery
12.04	Thu	MySQL Disaster Recovery
12.09	Tue	Data Privacy Data Security		Project App Dev 2
12.11	Thu	Indexing Final Review		Lab 5