Important Dates
- 09/16 Homework 1 given
- 09/30 Homework 1 due at 12:30pm (noon)
- 10/07 Homework 2 given
- 10/21 Homework 2 due at 12:30pm (noon)
- 11/06 Homework 3 given
- 11/18 Homework 3 due at 12:30pm (noon)
- 10/28 Mid Term Exam, 10:00 am - 11:30 am, SB104
- 12/10 Final Exam, 8:00 am - 10:00 am, SB104
- Course Project
- 09-11 Decision on application domain
- 11-11 Database model
- 11-25 Relational schema and DDL script
- 12-07 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/26 | 0. Course Organization | slides or handout (6 slides per page) |
| 08/28 | 1. Introduction | slides or handout (6 slides per page) |
| 09/02 | 2. The Relational Datamodel | slides or handout (6 slides per page) |
| 09/04 | ||
| 09/09 | 3. Formal Relational Query Languages | slides or handout (6 slides per page) |
| 09/11 | Discussion on Application Domain for Course Project | |
| 09/16 | 4. SQL - Introduction | slides or handout (6 slides per page) |
| 09/18 | ||
| 09/23 | ||
| 09/25 | ||
| 09/30 | 5. SQL - Intermediate (Views, Integrity Constraints, Access Control) | slides or handout (6 slides per page) |
| 10/02 | ||
| 10/07 | 6. SQL - Advanced (APIs for SQL Access, Procedural Constructs) | slides or handout (6 slides per page) |
| 10/09 | ||
| 10/14 | ||
| 10/16 | 7. ER-Model | slides or handout (6 slides per page) |
| 10/21 | ||
| 10/23 | ||
| 10/28 | Mid Term Exam | |
| 10/30 | ||
| 11/04 | 8. Database Design and Normal Forms | slides or handout (6 slides per page) |
| 11/06 | ||
| 11/11 | ||
| 11/13 | ||
| 11/18 | ||
| 11/20 | 9. Transactions | slides or handout (6 slides per page) |
| 11/25 | 10. Concurrency Control | slides or handout (6 slides per page) |
| 12/02 | ||
| 12/04 | 11. Storage and Index Structures | slides or handout (6 slides per page) |
| 12/10 | Final Exam |