CSPP 53001: Databases (Fall'09)

Location & Time Eckhart 202, 5:15pm - 8:10pm, Thursdays
Instructor Svetlozar Nestorov (svetlozarn@gmail.com) email for appointment
TA Xueyuan Zhou (zhouxy at uchicago.edu)
Textbook A First Course in Database Systems by Jeff Ullman, and Jennifer Widom

Date Announcement
10/22 The midterm will be on 11/5 in class, 5:15pm - 6:45pm.
10/14 The registration procedure for Gradiance and a new due date for HW1.
10/13 Subscribe to the class mailing list.
10/2 Class will start 15 minutes earlier at 5:15pm.
 
Week Date Topics Readings Assignments
1 10/1 Introduction, Entity-Relationship model and design slides 1, 4.1-4.4 Practice Problems, Solutions
2 10/8 Relational model, Functional dependencies, Normal forms slides 2.1-2.2,4.5-4.6,3.1-3.5 HW1
3 10/15 Relational algebra, SQL: Simple queries slides 5, 6.1-6.2 HW2
4 10/22 SQL: Subqueries, Aggregation, Schemas, Modifications slides 6.2-6.5
5 10/29 SQL: Joins, Views, Indexes, Constraints slides 6.3, 7.1-7.2, 8.1-8.4 HW3
6 11/5 Midterm, Triggers, Stored Procedures slides 7.5, 9.1-9.4
7 11/12 Transactions, Authorization slides 6.6, 10.1 HW4