This schedule is tentative and subject to change. All readings are in Fundamentals of Database Systems, Seventh Edition.
| Week | Date | Topic |
Reading |
| 1 | August 20 | Syllabus review, course requirements, etc. | Ch. 1 |
| August 22 | Database Concepts | Ch. 2 | |
| 2 | August 27 | The Entity-Relationship Model | Ch. 3 |
| August 29 |
The Entity-Relationship (ER) model |
Ch. 3 | |
| 3 | September 3 |
Labor Day holiday |
|
| September 5 | Basic SQL | Ch. 6 | |
| 4 | September 10 | The Enhanced Entity-Relationship Model | Ch. 4 |
| September 12 | The Enhanced Entity-Relationship Model | Ch. 4 | |
| 5 | September 17 |
More SQL |
Ch. 7 |
| September 19 | The Relational Model and Relational Database Constraints | Ch. 5 | |
| 6 | September 24 | The Relational Model and Relational Database Constraints | Ch. 5 |
| September 26 | Relational database design by ER to EER mapping | Ch. 9 | |
| 7 | October 1 | Relational database design by ER to EER mapping | Ch. 9 |
| October 3 | Midterm Review | ||
| 8 | October 8 |
Exam 1 on Chapters 1-5, 7, and 9 |
|
| October 10 |
Relational Algebra and Calculus |
Ch. 8 | |
| 9 | October 15 |
Relational Algebra and Calculus |
Ch. 8 |
| October 17 | File Structures | Ch. 16 | |
| 10 | October 22 | File Structures / Index Structures | Ch. 16, 17 |
| October 24 | Index Structures | Ch. 17 | |
| 11 | October 29 | Functional Dependency and Normalization | Ch. 14 |
| October 31 | Functional Dependency and Normalization | Ch. 14 | |
| 12 | November 5 | Design Algorithms & Further Dependencies | Ch. 15 |
| November 7 | Design Algorithms & Further Dependencies | Ch. 15 | |
| 13 | November 12 | Query Processing & Optimization | Ch. 18 |
| November 14 | Query Processing & Optimization | Ch. 19 | |
| 14 | November 19 | Fall Break for Thanksgiving | |
| November 21 | Fall Break for Thanksgiving | ||
| 15 | November 26 | Transaction Processing | Ch. 20 |
| November 28 | Concurrency Control | Ch. 21 | |
| 16 | December 3 | Exam Review | |
| December 5 | Exam 2 at 8:30 to 9:45 in the TI
Auditorium, ECSS 2.102 Covers Chapters 8, 14, 15, 16, 17, 18, 19, and the material on transactions and concurrency (In class) |
||