DM26, Fall 2005 - Weekly Note 5

There are no lectures or exercise classes in Week 42 (Oct. 17 to Oct. 21) due to the fall break.

Lecture October 5

Use of the PostgreSQL system at IMADA. Database application programming, in particular JDBC. Stored procedures.

Reading

Note on using PostgreSQL at IMADA. Ramakrishnan and Gehrke: Chapter 6 (you can skip 6.6). Note on using JDBC with PostgreSQL at IMADA.

Lecture October 12 (Expected Contents)

Normal forms: functional dependencies, BCNF.

Reading

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

Exercises October 12/28

Exercises 5.3, 5.7, 6.1, and 6.8 in Ramakrishnan and Gehrke. For 6.8, note that test data for this exercise was given on Weekly Note 4 (so you can easily test your code).