DM26, Fall 2006 - Weekly Note 7

Lecture October 13

Finishing of SQL. JDBC. Stored procedures. Handout and discussion of course project (with addendum for HA-Dat students).

Reading

Ramakrishnan and Gehrke: Rest of Chapter 5. Section 3.6. Section 6.3. Section 6.5.

Note on using JDBC with PostgreSQL at IMADA.

Remarks

Numerous ways to mix programming with SQL have been defined. We focus on JDBC (where the relevant material is Section 6.3 in the textbook, the note on using JDBC with PostgreSQL at IMADA, and the JDBC documentation linked to at the bottom of the note), and on stored procedures (which you should only know on the conceptual level, as described in Section 6.5 in the textbook). It may be beneficial to browse the rest of Chapter 6 (6.1, 6.2, and 6.4) lightly, but this will not be curriculum.

Lecture October 27 (Expected Contents)

Schema refinement: functional dependencies and normal forms.

Reading

Ramakrishnan and Gehrke: Sections 19.1-7.

Exercises October 30

Exercises 5.3 (only the odd-numbered questions), 5.4, and 6.8 in Ramakrishnan and Gehrke. Note that test data was given on Weekly Note 6 (so you can easily test your code).