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