Lectures

Class slides will generally be posted. You are highly encouraged to attend all classes.

Date Slides Book Sections
September 6 Introduction to the Course
September 11 Introduction to Databases Chap. 1
September 13 Relational Algebra, The Relational Model Chap. 2, Chap. 6.1
September 18 Entity-Relationship Modelppt version Chap. 7.2
September 20 Tuple Relational Calculusppt version Chap. 6.2
September 25 SQL 1ppt version Chap. 3
September 27 SQL 2 Chap. 3
October 2 Constraints Chap. 4.4
October 4 Normalization Chap. 8
October 9 Indigenous Peoples Day - No Class
October 11 Storage and Disks Chap. 10
October 16 Quiz 1
October 18 File Organization Chap. 11
October 23 Indexing: B-trees Chap. 11
October 25 Indexing: External Hashing Chap. 12
October 30 Query Processing Chap. 13
November 1 Query Processing Continued Chap. 14
November 6 Transactionsppt version Chap. 15
November 8 Transactions Continued
November 13 Quiz 2
November 15 Concurrency Control Chap. 15
November 20 Guest Lecture
November 22 Thanksgiving -- No Class
November 27 Recoveryppt version Chap. 16
November 29 Distributed Databases Chap. 19
December 4 Parallel Databases Chap. 18
December 6 Quiz 3