CS 425: Database Organization - Fall 2017

Important Dates

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/210. Course Organizationslides or handout (6 slides per page)
08/231. Introductionslides or handout (6 slides per page)
08/282. The Relational Datamodelslides or handout (6 slides per page)
08/30
09/063. Formal Relational Query Languages slides or handout (6 slides per page)
09/11Discussion on Application Domain for Course Project
09/134. SQL - Introductionslides or handout (6 slides per page)
09/18
09/20
09/255. SQL - Intermediate (Views, Integrity Constraints, Access Control)slides or handout (6 slides per page), SQL script developed in class
09/27
10/026. SQL - Advanced (APIs for SQL Access, Procedural Constructs)slides or handout (6 slides per page)
10/04
10/09
10/117. ER-Modelslides or handout (6 slides per page)
10/16
10/18
10/23Mid Term Exam
10/258. Database Design and Normal Formsslides or handout (6 slides per page)
10/30
11/06
11/08
11/13
11/159. Transactionsslides or handout (6 slides per page)
11/2010. Concurrency Controlslides or handout (6 slides per page)
11/27
11/3911. Storage and Index Structures slides or handout (6 slides per page)
12/05Final Exam