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