DM26, Fall 2006 - Weekly Note 9

Updated version of weekly note 9: lectures and exercise classes are switched around the coming week - there will be lectures Monday, November 13, and exercise classes Friday, November 17.

Announcement

All students of Imada should once a year attend a "Studieorienterende Samtale" (a 10 minutes meeting with at faculty member to guide you in the planning of your study). The meetings are held currently, in Week 45 and 46 (i.e., this week and the next). Sign up for at time slot at the departemental office.

HA-dat students are not required to attend such a meeting.

Lecture November 3

More on schema refinement and normalization: Third Normal Form, dependency preserving decompositions, minimal cover.

Reading

Ramakrishnan and Gehrke: Rest of Sections 19.1-7.

Lecture November 10

Start on second part of the course (DBMS implementation): Storage and indexing.

Reading

Ramakrishnan and Gehrke: Chapters 8-9 (of which Chapter 9 is to some extent left for your own reading).

Lecture November 13 (Expected Contents)

More on storage and indexing.

Reading

Ramakrishnan and Gehrke: Chapters 10 and 11.

Exercises November 17

Exercises 9.2, 9.4, 9.12, 8.2, 8.3, 8.5, 8.9, and 8.11 in Ramakrishnan and Gehrke.