This schedule is tentative and subject to change. All readings are in Fundamentals of Database Systems, Seventh Edition.
| Week | Date | Topic |
Reading |
| 1 | January 21 | Syllabus review, course requirements, etc. Database Concepts The Entity-Relationship (ER) Model |
Ch. 1, 2 |
| 2 | January 28 | Basic SQL and More SQL Database Programming |
Ch. 6,7 Ch. 10 |
| 3 | February 4 | No class | |
| 4 | February 11 |
The Enhanced Entity-Relationship Model |
Ch. 3, 4,5 |
| 5 | February 18 |
Relational database design by ER to EER mapping Midterm Review Test 1 on Chapters 1-7, and 9 |
Ch. 9 |
| 6 | February 25 | Relational Algebra and Calculus | Ch. 8 |
| 7 | March 4 | File Structures; Index Structures | Ch. 16, 17 |
| 8 | March 11 | No Class -- Spring Break | |
| 9 | March 18 |
No Class |
|
| 10 | March 25 |
Functional Dependency and Normalization Design Algorithms & Further Dependencies |
Ch. 14 Ch. 15 |
| 11 | April 1 |
Query Processing & Optimization |
Ch. 18 Ch. 19 |
| 12 | April 8 | Transaction Processing Concurrency Control |
Ch. 20 |
| 13 | April 15 | No class -- Good Friday | |
| 14 | April 22 | Database Recovery Techniques Test 2 review |
|
| 15 | April 30 | No Class |