This schedule is tentative and subject to change.
| Date | Topic |
Reading |
| January 13, 2009 | Syllabus review, course requirements, etc. | Ch. 1 |
| January 15, 2009 | Database Concepts | Ch. 2 |
| January 20, 2009 | The Entity-Relationship Model | Ch. 3 |
| January 22, 2009 |
The Entity-Relationship Model |
Ch. 3 |
| January 27, 2009 |
SQL Server tutorial; The Enhanced Entity-Relationship Model |
Ch. 4 |
| January 29, 2009 | The Enhanced Entity-Relationship Model | Ch. 4 |
| February 3, 2009 | The Relational Model | Ch. 5 |
| February 5, 2009 | The Relational Model | Ch. 5 |
| February 10, 2009 |
SQL Programming |
Ch. 8 |
| February 12, 2009 | SQL Programming / JDBC | Ch. 8 |
| February 17, 2009 | SQL Programming | Ch. 9 |
| February 19, 2009 | Relational database design by ER to EER mapping | Ch. 7 |
| February 24, 2009 | Relational database design by ER to EER mapping | Ch. 7 |
| February 26, 2009 | Midterm Review | |
| March 3, 2009 |
Exam 1 on chapters 1-5 and 7-9. |
|
| March 5, 2009 |
Relational Algebra and Calculus |
Ch. 6 |
| March 10, 2009 | Relational Algebra and Calculus | Ch. 6 |
| March 12, 2009 | Functional Dependency and Normalization | Ch. 10 |
| March 17 , 2009 | Spring Break | |
| March 19, 2009 | Spring Break | |
| March 24 2009 | Functional Dependency and Normalization | Ch. 10 |
| March 26, 2009 | Design Algorithms & Further Dependencies | Ch. 11 |
| March 31, 2009 | Design Algorithms & Further Dependencies | Ch. 11 |
| April 2, 2009 | Practical Database Design | Ch. 12 |
| April 7, 2009 | Disk Storage, File Structures | Ch. 13 |
| April 9, 2009 | Index structures. | Ch. 14 |
| April 14, 2009 | Query Optimization | Ch. 15 |
| April 16, 2009 | Query Optimization / Physical Database | Ch. 15, 16 |
| April 21, 2009 | Transaction Processing | Ch. 17 |
| April 23, 2009 | Concurrency Control | Ch. 18 |
| April 28, 2009 | Exam Review | |
| April 30, 2009 | Exam 2 on chapters 6, 8-18 | |