DM26, Fall 2005 - Weekly Note 7

Announcement: Again this year, the faculty hosts the event KarriereKick, where students can learn about future jobs and career opportunities. The event takes place Thursday, November 17, at 15:00, in U45. Please sign up beforehand at www.karrierekick.sdu.dk. Participation is free.

Lecture October 26

More on normal forms: Armstrongs axioms, closures, decompositions, lossless-join and dependency-preserving decompositions, 3NF.

Reading

Ramakrishnan and Gehrke: Sections 19.4-19.6.1.

Lecture November 2 (Expected Contents)

Even more on normal forms: Minimal cover, multivalued dependencies, 4NF. Start on second part of the course (DBMS implementation): Storage and indexing.

Reading

Ramakrishnan and Gehrke: Rest of Chapter 19 (you can skip 19.8.3, 19.8.4, and 19.9). Chapters 8 and 9.

Exercises November 2/11

Exercises 19.5 (in question (a), just determine whether the relation is in BCNF), 19.10, 19.13, 19.19, 19.20, and 19.27 in Ramakrishnan and Gehrke.