August 2007
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19

Week 1 
20

Course overview, introduction (Chapter 1)
21 22

ER model (Chapter 2)
23 24

Relational model/ER to Relational (Chpater 3)
25
26

Week 2 
27

Relational model/ER to Relational
28 29

Relational model/ER to Relational
30 31

Storing data: disks and files (1) (Chapter 9)

Add Deadline

Assignment 1 Due Solution
 

September 2007
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
            1
2

Week 3 
3

Labor Day
4

Storing data: disks and files (2)

Monday Schedule
5

Relational algebra (Chapter 4)
6 7

Relational algebra

Assignment 2 Due Solution
8
9

Week 4 
10

SQL (Chapter 5)
11 12

SQL
13 14

SQL (In MI303 - lab)

Assignment 3 Due Solution
15
16

Week 5 
17

File and Indices (Chapter 8)
18 19

Tree-structured indexing (Chapter 10)
20 21

Review

Assignment 4 Due Solution
22
23

Week 6 

X-week
24

6-Week Exam
25 26

Tree-structured indexing
27 28

Tree-structured indexing
29
30

Week 7 
           

October 2007
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
  1

Hash-based indexing (Chapter 11)

Assignment 5 Due Solution
2 3

External sorting (Chapter 13)

Assignment 6 Due Solution
4 5

External Sorting
6
7

Week 8 
8

Columbus Day
9 10

Evaluating relational operators (Chapter 14) - Part 1

Assignment 7 Due Solution
11 12

Evaluating relational operators

Assignment 8 Due Solution
13
14

Week 9 
15

Evaluating relational operators (Chapter 14) - Part 2
16 17

Evaluating relational operators
18 19

Evaluating relational operators
20
21

Week 10 
22

Evaluating relational operators
23 24

Query optimization (Chapter 15)

Assignment 9 Due Solution
25 26

Review

Project 1 Due
27
28

Week 11 

X-week
29

12-Week Exam
30 31

Query optimization
     

November 2007
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
        1 2

Exam Discussion
3
4

Week 12 
5

No classes
6 7

Query optimization
8 9

Query optimization

Drop Deadline
10
11

Week 13 
12

Veteran's Day (observed)
13 14

Start Project2
15 16

Concurrency control (Chapter 16,17) - Part 1

Start Registration
17
18

Week 14 
19

Project discussion
20 21

Concurrency control (Chapter 16,17) - Part 2
22

Thanksgiving
23

Digestion Day
24
25

Week 15 
26

Crash recovery (Chapter 18)
27 28

Ethics Reading: Data misuse
Public records
Code
29 30

Project work (in MI303)

End Registration
 

December 2007
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
            1
2

Week 16 
3

Schema refinement and normal forms (Chapter 19)

Assignment 10 Due (Extra credit) Solution
4 5

Course wrap-up
Project demos

Assignments 11, 12 Due (Extra credit) Solution 11 Solution 12

Project 2 Due
6

Reading Day
7

Final Exam - 0755

Start Finals
8
9 10 11 12 13 14

End Finals
15
16 17 18

Grades Due
19 20 21 22
23 24 25

Christmas Day
26 27 28 29
30 31