Databases
Schedule: Subject To Change
# Day Date Chapter Topics Due at 11:55 pm
1 M 9/10 1 Introduction
2 W 9/12 9 Storing data: disks and files
3 F 9/14 9 Storing data: disks and files  
4 M 9/17 2 Database design, ER Model Warmup
5 W 9/19 2 Database design, ER Model
6 F 9/21 3 Relational Model  
7 M 9/24 3 Relational Model
8 W 9/26 4 Relational Algebra Minibase 1
9 F 9/28 4 Relational Algebra  
10 M 10/1 4 Relational Algebra Problem Set 1
11 W 10/3 5 SQL
12 F 10/5 5 SQL  
13 M 10/8 5 SQL Minibase 2
14 W 10/10 Exam 1
15 F 10/12 8 Storage and indexing  
M 10/15 BREAK
16 W 10/17 10 Tree structured indexing
17 F 10/19 10 Tree structured indexing  
18 M 10/22 11 Hash indexing PostgreSQL 1
19 W 10/24 11 Hash indexing
20 F 10/26 12 Overview of query evaluation  
21 M 10/29 13 External sorting Problem Set 2
22 W 10/31 14 Evaluation of relational operators
23 F 11/2 15 Query optimization  
24 M 11/5 15 Query optimization Minibase 3
25 W 11/7 19 Schema refinement and normal forms
26 F 11/9 19 Schema refinement and normal forms  
27 M 11/12 15 Transaction management Final assignment
28 W 11/14 15 Transaction management
self or Su 11/19 Exam 2