Important Dates
- 09/12 Homework 1 given
- 09/26 Homework 1 due at 12:30pm (noon)
- 10/03 Homework 2 given
- 10/17 Homework 2 due at 12:30pm (noon)
- 11/02 Homework 3 given
- 11/14 Homework 3 due at 12:30pm (noon)
- 10/24 Mid Term Exam, 1:50 pm - 3:05 pm, RE 104
- 12/05 Final Exam, 2:00 pm - 4:00 pm, HH, BALLROOM
- Course Project
- 09/12 Decision on application domain
- 11/14 Database model
- 11/21 Relational schema and DDL script
- 12/11 Application implemented
Schedule
The course schedule and linked slides will be updated over time. The slides are a modified version of the slides from Avi Silberschatz created for Database System Concepts.
For convenience, here is a combined versions of all slides and all handouts (6 slides per page).
| 08/22 | 0. Course Organization | slides or handout (6 slides per page) |
| 08/24 | 1. Introduction | slides or handout (6 slides per page) |
| 08/29 | 2. The Relational Datamodel | slides or handout (6 slides per page) |
| 08/31 | ||
| 09/07 | 3. Formal Relational Query Languages | slides or handout (6 slides per page) |
| 09/12 | Discussion on Application Domain for Course Project | |
| 09/14 | 4. SQL - Introduction | slides or handout (6 slides per page) |
| 09/19 | ||
| 09/21 | ||
| 09/26 | 5. SQL - Intermediate (Views, Integrity Constraints, Access Control) | slides or handout (6 slides per page), SQL script developed in class |
| 09/28 | ||
| 10/03 | 6. SQL - Advanced (APIs for SQL Access, Procedural Constructs) | slides or handout (6 slides per page) |
| 10/05 | ||
| 10/12 | ||
| 10/17 | 7. ER-Model | slides or handout (6 slides per page) |
| 10/19 | ||
| 10/24 | Mid Term Exam | |
| 10/26 | ||
| 10/31 | 8. Database Design and Normal Forms | slides or handout (6 slides per page) |
| 11/02 | ||
| 11/07 | ||
| 11/09 | ||
| 11/14 | ||
| 11/16 | 9. Transactions | slides or handout (6 slides per page) |
| 11/21 | 10. Concurrency Control | slides or handout (6 slides per page) |
| 11/28 | ||
| 11/30 | 11. Storage and Index Structures | slides or handout (6 slides per page) |
| 12/05 | Final Exam |