
| Weekday | Date | Topic | Book Chapters | Lecture Notes | |
| Tuesday | 1/6/2008 | Syllabus; Motivation on DBs; DBMSs | 1; | Get Notes | |
| Thursday | 1/8/2008 | Introduction to Database Models | 2.1; 4 | Get Notes | |
| ER Design; basics | 4.1 | ||||
| Tuesday | 1/13/2008 | ER Design; basics | 4.1, 4.2 | Get Notes | |
| Thursday | 1/15/2008 | ER Design; constraints; | 4.3 | Get Notes | |
| Weak entity sets; Relational Model | 4.3; 4.4; 2.1, 2.2 | ||||
| Tuesday | 1/20/2008 | Relational Model; E/R to Relational | 2.2; 4.5 | Get Notes | |
| Thursday | 1/22/2008 | E/R to Relational | 4.5; 4.6 | Get Notes | |
| Review for Quiz 1 | |||||
| Tuesday | 1/27/2008 | Quiz #1; Assignment #1; out | |||
| Thursday | 1/29/2008 | Discuss Assignment #1, ER to Relational | 4.5 | Get Notes | |
| Basic DDL, Relational Algebra | 2.3, 2.4 | ||||
| Tuesday | 2/3/2008 | Relational Algebra | 2.4 | Get Notes | |
| Thursday | 2/5/2008 | Quiz #1; Relational Algebra | 2.5 | Get Notes | |
| SQL | 6.1 | ||||
| Tuesday | 2/10/2008 | SQL; Assignment #1 DUE [Extended to Thursday 2/12] | 6.2 | Get Notes | |
| Thursday | 2/12/2008 | Review for Quiz #2 | Get Notes | ||
| Tuesday | 2/17/2008 | Quiz #2; Assignment #2 OUT | |||
| Thursday | 2/19/2008 | SQL Review | Get Notes | ||
| SQL Advanced | |||||
| Tuesday | 2/24/2008 | More SQL | 6 | Get Notes | |
| Thursday | 2/26/2008 | SQL;Assignment #2 DUE; | Get Notes | ||
| DB Programming | |||||
| Tuesday | 3/3/2008 | SQL Review | Get Notes | ||
| Thursday | 3/5/2008 | SQL Constraints | Get Notes | ||
| Quiz #3 | |||||
| Tuesday | 3/10/2008 | Spring Break | |||
| Thursday | 3/12/2008 | Spring Break | |||
| Spring Break | |||||
| Tuesday | 3/17/2008 | SQL: Assertions, Triggers | 7.5,7.6 | Get Notes | |
| Thursday | 3/19/2008 | SQL: Stored Procedures | 9.4 | Get Notes | |
| Call Level Interfaces: ODBC; JDBC; etc. | 9.5 | ||||
| Tuesday | 3/24/2008 | Transactions | 6.6 | Get Notes | |
| Thursday | 3/26/2008 | Assignment #3 DUE; Transactions; Functional Dependencies | 6.6; 3 | Get Notes | |
| Review for Quiz #4 | |||||
| Tuesday | 3/31/2008 | Quiz #4 / Assignment #4 out | |||
| Thursday | 4/2/2008 | Relational Design: Functional Dependencies | 3; 3.1; 3.2 | Get Notes | |
| Relational Design: FDs; Decomposition | 3.2; 3.3 | ||||
| Tuesday | 4/7/2008 | Relational Design: FDs; Normal Forms | 3.2; 3.3; 3.4 | Get Notes | |
| Thursday | 4/9/2008 | Relational Design: FDs; Normal Forms Assignment #4 Due; Assignment #5 Out | 3.4; 3.5 | Get Notes | |
| Relational Design: FDs; Normal Forms | 3.4; 3.5 | ||||
| Tuesday | 4/14/2008 | Normal Forms; Multivalued Dependencies | 3.4; 3.5 | Get Notes | |
| Thursday | 4/16/2008 | BCNF Practice | Get Notes | ||
| Semester Review | |||||
| Tuesday | 4/21/2008 | Quiz #5; Assignment #5 DUE | |||
| Thursday | 4/23/2008 | Reading Day; No class | |||
| Tuesday | 4/28/2008 | No class | |||
| Thursday | 4/30/2008 | Final Exam; |