| 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 | ||||