Schedule

Date		Topic	Reading	Due
08.29	Thu	Intro to Databases Relational Model	Relational Fundamentals
09.03	Tue	SQL Basics	SQL By Example Ch. 2-3	Quiz 1 Discussion 1
09.05	Thu	SQL Joins	SQL By Example Ch. 4, 7	SQL Ex 1
09.10	Tue	Database Modeling	Database Design Ch. 2	Quiz 2
09.12	Thu	Business Database Modeling		Discussion 2 SQL Ex 2
09.17	Tue	Implementing Models
09.19	Thu	More SQL		Model Ex 1
09.24	Tue	Conditional Logic Self-Referential Relationships	Case Expression
09.26	Thu	Null Values Inheritance SQL DML Test 1 Review		Model Ex 2 SQL Ex 3
10.01	Tue	Storm Recovery (No Class)
10.03	Thu	Test 1
10.08	Tue	MySQL and MS Access Database Development
10.10	Thu	Modeling Tips		Lab 1
10.15	Tue	Project Intro Normal Forms		Lab 2
10.17	Thu	Project Discussion More Normal Forms		Project Draft ER Model
10.22	Tue	Fall Break (No Class)
10.24	Thu	Views Denormalization		Project Final ER Model
10.29	Tue	Data Integrity
10.31	Thu	Database Programming		Project DB Implementation
11.05	Tue	Database Programming Test 2 Review
11.07	Thu	Test 2
11.12	Tue	Procedural SQL	Stored Procedure Tutorial, Sections 1-2	Lab 3
11.14	Thu	Procedural SQL, cont.	Stored Procedure Tutorial, Sections 5-6
11.19	Tue	Transactions		Project App Dev 1
11.21	Thu	Transactions, cont.	Transactions	Lab 4
11.26	Tue	Thanksgiving Break (No Class)
11.28	Thu	Thanksgiving Break (No Class)
12.03	Tue	Disaster Recovery
12.05	Thu	MySQL Disaster Recovery
12.10	Tue	Data Privacy Data Security		Project App Dev 2
12.12	Thu	Indexing Final Review		Lab 5