DM26, Fall 2004 - Weekly Note 5

Lecture September 29

Normal forms: functional dependencies, BCNF.

Reading

Ramakrishnan and Gehrke: Sections 19.1-3 and Section 19.4.1.

Remarks

Once you get an IMADA computer account, you automatically have an email address your_loginname@imada.sdu.dk, at which you may receive mails. In particular, you may receive DM26 relevant mails. Be sure that you read mails sent to your IMADA address - instructions for this, or for forwarding mails to another account of yours, can be found at the FAQ of the IMADA sysadmins.

Instructor Niels Hvidberg Kjeldsen has made a solution for Exercise 5.2 in Ramakrishnan and Gehrke.

Lecture October 6 (Expected Contents)

More on normal forms: 3NF, multivalued dependencies, 4NF.

Reading

Ramakrishnan and Gehrke: The rest of Chapter 19.

Exercises October 4

Exercises 3.8, 3.10, 3.19 (only question 1), 5.7, and 5.3 (in that order) in Ramakrishnan and Gehrke.

Exercises October 18

Exercises 19.1 (except questions 3 and 4), 19.2, 19.3, 19.7 (but in question (b), only consider whether the relation is in 3NF or BCNF), and 19.15 in Ramakrishnan and Gehrke.