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