Week of | Monday | Wednesday | Friday |
January 3 | Introduction 1 |
E/R diagrams 2.0.0-2.4.3, 2.5.0-2.5.2 |
Relations 3.0-3.4 |
January 10 | E/R to Relations 3.5.0-3.5.5 |
Functional Dependencies 15.0-15.4 |
Normalization 15.5-15.7 Homework 1 due Project Phase I due |
January 17 |
Martin Luther King, Jr. Day No Class |
Views 3.6 |
Relational Algebra 4.0-4.2 |
January 24 | SQL 5.0-5.3 |
SQL 5.4-5.6 |
SQL Homework 2 due |
January 31 | SQL and Constraints 5.10-5.13 Project Phase II due |
Data Storage 7.0-7.1, 7.3-7.5 | Files and Indices 8 |
Homework 3 due
February 7 | Midterm, in class | B+ Trees 9.0-9.5; 10.0-10.1 |
Query Execution 12.0-12.2 |
February 14 | Query Execution 12.5.0-12.5.2, 12.8 Project Phase III due |
Query Optimization 13 |
Query Optimization 14.0.0-14.3.4 Homework 4 due |
February 21 | President's Day No Class |
Concurrency Control 18 |
Concurrency Control
19.0.0-19.3.1 |
February 28 | Recovery 20 |
Recovery | Object Databases 25.0-25.6 Homework 5 due |
March 6 | Object Databases; SQL3
25.7-25.10 |
TBA TBA Project Phase IV due |
Review |
March 13 | FINAL EXAM, 2:30-4:20 |