Daily Schedule for CSE444

NOTE: This schedule is subject to change ! ! !

Key:

Homework 3 due
Week ofMonday 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
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