Important Dates
- 09/12 Homework 1 given
- 09/26 Homework 1 due at 11:59pm (one minute before midnight)
- 10/03 Homework 2 given
- 10/20 Homework 2 due at 11:59pm (one minute before midnight)
- 11/09 Homework 3 given
- 11/23 Homework 3 due at 11:59pm (one minute before midnight)
- 10/23 Mid Term Exam, 3:15 pm - 4:30 pm, SB 104
- 12/05 Final Exam, 2:00 pm - 4:00 pm, SB 104
- 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/21 | 0. Course Organization | slides or handout (6 slides per page) |
| 08/23 | 1. Introduction | slides or handout (6 slides per page) |
| 08/28 | 2. The Relational Datamodel | slides or handout (6 slides per page) |
| 08/30 | ||
| 09/06 | 3. Formal Relational Query Languages | slides or handout (6 slides per page) |
| 09/11 | Discussion on Application Domain for Course Project | |
| 09/13 | 4. SQL - Introduction | slides or handout (6 slides per page) |
| 09/18 | ||
| 09/20 | ||
| 09/25 | 5. SQL - Intermediate (Views, Integrity Constraints, Access Control) | slides or handout (6 slides per page), SQL script developed in class |
| 09/27 | ||
| 10/02 | 6. SQL - Advanced (APIs for SQL Access, Procedural Constructs) | slides or handout (6 slides per page) |
| 10/04 | ||
| 10/09 | ||
| 10/11 | 7. ER-Model | slides or handout (6 slides per page) |
| 10/16 | ||
| 10/18 | ||
| 10/23 | Mid Term Exam | |
| 10/25 | 8. Database Design and Normal Forms | slides or handout (6 slides per page) |
| 10/30 | ||
| 11/06 | ||
| 11/08 | ||
| 11/13 | ||
| 11/15 | 9. Transactions | slides or handout (6 slides per page) |
| 11/20 | 10. Concurrency Control | slides or handout (6 slides per page) |
| 11/27 | ||
| 11/39 | 11. Storage and Index Structures | slides or handout (6 slides per page) |
| 12/05 | Final Exam |