CS 235: Introduction to Databases

Fall 2005 Schedule

This schedule may be revised throughout the quarter.  The latest version is available online at
 http://www.classes.cs.uchicago.edu/archive/2005/fall/23500-1/schedule.html

 
Date Topic Slides Readings Assignments
9/27 Introduction, Entity-Relationship model pdf 1, 2.1
9/29 Entity-Relationship design pdf 2 Practice Problems
10/4 Relational model, Online dating pdf 3.1-3.5 Assignment 1
10/6 Functional and multivalued dependencies, Normal forms pdf 3.4-3.7  
10/11 Relational algebra pdf 5 Assignment 2
10/13 SQL: Simple queries pdf 6.1-6.2  
10/18 SQL: Subqueries, Aggregation pdf 6.3-6.4 Assignment 3
10/20 SQL: Modifications, Schemas, Views pdf 6.5-6.7  
10/25 Constraints, Triggers pdf 7 Assignment 4
10/27 Persistent stored modules pdf 8.1-8.2, Notes
11/1 Midterm Exam   Assignment 5
11/3 Database connectivity 8.3-8.5, Notes  
11/8 Transactions, Authorization pdf 8.6-8.7 Assignment 6
11/10 Indexing pdf 6.6.5, 6.6.6, Notes  
11/15 Datalog pdf 10.1-10.3 Assignment 7
11/17 Data warehousing, Data mining pdf Notes
11/22 Semistructured data, XML pdf 4.6-4.7  
11/24 No class    
11/29 XPath, XQuery pdf Notes  
12/1 Review    

Last modified: Tue Nov 29 15:09:16 CST 2005