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