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