Schedule
| Dates | Tuesday | Thursday | Readings |
|---|---|---|---|
| Sept 5,7 | First class is Thurs, Sept 7 |
Welcome, goals of a DB DBMS objectives DDL, DML |
Chaps 1 and 2 |
| Sept 12,14 | Relational model DB integrity E-R model |
E-R model EER enhancements |
Chaps 3 and 4 (except 4.6) |
| Sept 19,21 | ER/EER conversion to relational |
functional dependencies closure of FD set closure of attr set QUIZ 1 |
Chaps 5 and 7.1-7.2 and 10.1-10.2 |
| Sept 26,28 | canonical cover update anomalies |
lossless join dependency preservation normalization |
Chapter 10 and 11.1 |
| Oct 3,5 | normalization QUIZ 2 |
3NF and BCNF decomposition Midterm review |
Chapter 11 |
| Oct 10,12 | MIDTERM | relational algebra | Chapter 6.1-6.5 |
| Oct 17,19 | relational algebra | Basic SQL | Chapter 8 |
| Oct 24,26 | Advanced SQL |
update queries embedded/dynamic SQL QUIZ 3 |
Chapter 8 and Sections 9.1-9.2.3 |
| Oct 31, Nov 2 | QBE relational calculus OODB model |
OODB model OQL |
Section 6.6 and Appendix C |
| Nov 7,9 | Oral Presentations |
Oral Presentations QUIZ 4 |
Chapters 20-21 |
| Nov 14 |
DB applications review for final |
Skim Chapters 28-29 | |
| Exam Week | Final: Tues, November 21, 2:30-4:30pm in Olin 106 | ||