## Class Schedule and Lecture Notes:

The class calendaris kept online in both [HTML]and [ ical]format.
This schedule is subject to change so check it frequently.  In particular, check for changes to duedates and guest lectures.

Note: in general, the pdf files are larger (in bytes) than the ppt files.

 WK Class/Date Topic Book Chapter Events Lecture  Notes Section Notes 1 T 1/21 Introduction 1 [6up PDF] [ppt] Th 1/23 The Relational Model 3 [4up PDF] [ppt] 2 T 1/28 Storing Data: Disks and Files 9 [6up PDF] [ppt] Exercise Solution Th 1/23 File Organizations and Indexing 8 [6up PDF] [ppt] Exercise Solution 3 T 2/4 Tree-Structured Indexes 10 [6up PDF] [ppt] BTree demo Exercise Solution Th 2/6 External Sorting 11 [6up PDF] [ppt] 4 T 2/18 Single-Table Query Processing all over! [6up PDF] [ppt] Th 2/13 Single-Table QP, cont. 5 T 2/18 The Entity-Relationship Model 2 [6up PDF] [ppt] Exercise Solution Th 2/20 ER-to-relational mappings; Relational Algebra 2;4 [6up PDF] [ppt] [6up PDF] [ppt] 6 T 2/25 Relational Calculus 4 [6up PDF] [ppt] Exercise Solution Notes Th 2/27 SQL 5 [6up PDF] [ppt] 7 T 3/4 SQL II 5 [6up PDF] [ppt] Th 3/6 SQL III 5 [6up PDF] [ppt] Exercise Solution Midterm review session Part 1[ppt] [pdf] Part 2[ppt] [pdf] Part 3 [ppt] [pdf] 8 T 3/11 Relational Operators 14 [6up PDF] [ppt] Exercise Solution Th 3/13 Query Optimization 12/15 [6up PDF] [ppt] Exercise Solution 9 T 3/18 Query Optimization, cont. 12/15 Th 3/20 Query Optimization, cont. 12/15 10 T 3/25 Spring Break Th 3/27 Spring Break 11 T 4/1 Query Optimization, cont. Th 4/3 Boolean Search not in book [6up PDF] [ppt] 12 T 4/8 Functional Dependencies & Normalization 19 [6up PDF] [ppt] Th 4/10 FDs and Normalization, cont. 19 [6up PDF] [ppt] Notes Textbook 19.8 Sol Textbook 19.10 Sol 13 T 4/15 Physical Design and Tuning 20 [6up PDF] [ppt] Th 4/17 Introduction to Transactions 16 [6up PDF] [ppt] 14 T 4/22 Concurrency Control 17 [6up PDF] [ppt] Exercise Solution Th 4/24 More concurrency control 17 [6up PDF] [ppt] Solution 15 T 4/29 Logging and Recovery 18 [6up PDF] [ppt] Exercise Solution Th 5/1 Logging and Recovery, cont. 16 T 5/6 XML and XQuery Guest Lecture [6up PDF] [ppt] Th 5/8 Object Relational Database Systems 23 [6up PDF] [ppt] 17 T 5/13 Ranked Retrieval & Final Notes not in book [search, 6up PDF] [search, ppt] [wrapup, 6up PDF] [wrapup, ppt] Final Review Session Part 1[ppt] Part 2[ppt]Part 3 [ppt]