Captain's Log: Database Management Systems, Spring 2012

1: January 18 (Wednesday)
2: January 20 (Friday)
Continue the relational model:
3: January 23 (Monday)
We practice how to express queries in the basic relational algebra, doing Exercises 2.4.4(c-i). Gradiance 1 due Tuesday night.
4: January 25 (Wednesday)
We state various types of constraints on tables (Section 2.5), and further illustrate the surprising power of basic relational algebra: We motivate design theory, the topic of Chapter 3.
5: January 27 (Friday)
Assignment 1 (on paper) due at noon.
Introduce the notion of functional dependencies (Sections 3.1 & 3.2, except 3.2.8), doing Exercises 3.1.1 and 3.2.1.
6: January 30 (Monday)
Gradiance 2 due tomorrow night.
7: February 1 (Wednesday)
Gradiance 3 due Thursday night.
8: February 3 (Friday)
9: February 6 (Monday)
Give back graded Assignment 1, and continue MVDs: Gradiance 4 due Tuesday night.
10: February 8 (Wednesday)
Wrap up Chapter 3: Briefly introduce E/R design (Chapter 4).
Gradiance 5 due Thursday night.
11: February 10 (Friday)
12: February 13 (Monday)
Gradiance 6 due Tuesday night.
13: February 15 (Wednesday)
Gradiance 7 due Thursday night.
14: February 17 (Friday)
Assignment 2 (on paper) due at noon.
15: February 20 (Monday)
Gradiance 8 due tonight
16: February 22 (Wednesday)
Exam I.
17: February 24 (Friday)
Introduce Datalog (Sections 5.3-5.4):
18: February 27 (Monday)
Wrap up Datalog: Embark on SQL (Chapter 6): Gradiance 9 due tomorrow night.
19: February 29 (Wednesday)
We present numerous features of SQL, including subqueries, covering much of Sections 6.1-6.4.
20: March 2 (Friday)
21: March 5 (Monday)
Assignment 4 (on paper) due at noon. Gradiance 10 due tomorrow (Tuesday) night.
22: March 7 (Wednesday)
Finish SQL: Gradiance 11 due tomorrow (Thursday) night.
23: March 9 (Friday)
Cover basic notions of
24: March 12 (Monday)
Finish Transactions: Embark on Concurrency Control: Gradiance Lab project (on Presidents) due tonight.
25: March 14 (Wednesday)
Advanced Lock-based protocols: Gradiance 12 due tonight.
26: March 16 (Friday)
Graded Assignment 4 given back.
Project out. Gradiance 13 due tonight.
March 19-23
Spring break.
March 26 (Monday)
Class canceled (instructor out of town)
March 28 (Wednesday)
Class canceled (instructor out of town)
Gradiance 14 due tonight.
March 30 (Friday)
Class canceled (instructor out of town)
27: April 2 (Monday)
Wrap up transaction management: Embark on some extra/advanced features of SQL (selected from Chapters 7-10):
28: April 4 (Wednesday)
Continue extra/advanced features of SQL:
29: April 6 (Friday)
Phase 1 of Project due at noon.
30: April 9 (Monday)
Gradiance 15 due tonight.
Gradiance 16 due tomorrow night.
31: April 11 (Wednesday)
Exam II.
32: April 13 (Friday)
After the motivating Exercise 8.4.2, introduce various index structures:
33: April 16 (Monday)
Continue Index structures: Hand back graded Phase I of Project.
34: April 18 (Wednesday)
Graded Exam 2 handed back and discussed.
Embark on Query Execution (Chapter 15): Gradiance 17 due tomorrow night.
April 20 (Friday)
Class canceled (All-University Open House)
35: April 23 (Monday)
Finish Query Execution: Gradiance 18 due tonight.
36: April 25 (Wednesday)
Embark on the Query Compiler (Chapter 16), with focus on Gradiance 19 due tonight.
37: April 27 (Friday)
Finish the Query Compiler: Phase 2 of Project due at 4pm. Each team should schedule a presentation with the GTA.
38: April 30 (Monday)
Instructor out of town.
Project demos with TA.
39: May 2 (Wednesday)
Instructor out of town.
Project demos with TA.
Gradiance 20 due tonight.
40: May 4 (Friday)
Review session, going through previous exam sets.
Gradiance 21 due Monday night.
May 8 (Tuesday)
Final exam, 4:10-6:00pm


Torben Amtoft