DM26, Fall 2004 - Weekly Note 7

Lecture October 20

Database application programming, in particular JDBC. Project description (ps, pdf) handed out. The deadline for the project is December 1.

Reading

Ramakrishnan and Gehrke: Chapter 6 and Section 7.5.

Note on using JDBC with PostgreSQL at IMADA.

Lecture October 27 (Expected Contents)

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

Reading

Ramakrishnan and Gehrke: Chapter 8, 9, and parts of 10.

Exercises October 25

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

Exercises November 1

Exercises 6.1, 6.8 (note that test data for this exercise was given on Weekly Note 4, so you can easily test your code), 6.9 (same note), 9.2, 9.4, 9.5, 9.6 (only question 5 and 6) in Ramakrishnan and Gehrke.