DM505, Spring 2007, 4th Quarter - Weekly Note 4

This week, there will be two lecture slots and one exercise slot.

Next week, there will be no lectures (the lecturer is travelling), and only a single exercise slot. This leaves extra time for working on the databse project, and you are strongly advised to do so.

In this course, we will be using PostgreSQL as DBMS. To use the PostgreSQL system at IMADA, you need to have an IMADA account (to log into IMADA machines) as well as a (separate) username and password for the PostgreSQL system.

Participants with an existing IMADA account should have received an email containing a username and a password for the PostgreSQL system (at their student email address), unless they appear to have an PostgreSQL account already. The lecturer should be contacted if this email has not reached you.

Participants without an existing IMADA account must first acquire one by contacting Anders Fredslund. The lecturer should be contacted afterwards, for creation of PostgreSQL user name and password.

The following note on using PostgreSQL at IMADA explains how to use the PostgreSQL system at IMADA (remote use through ssh is possible), and provides some sample data for trying out the system.

Lecture April 23

More on relational algebra. Start on query part of SQL.

Reading

Note on using PostgreSQL at IMADA. Kifer, Bernstein, and Lewis: Sections 5.1.2 and 5.2.1-7.

Lecture April 30 (Expected Contents)

More on SQL (nulls, views, data updates). SQL and programming. Start on normalization theory.

Reading

Note on using JDBC with PostgreSQL at IMADA. Kifer, Bernstein, and Lewis: Sections 5.2.8-10 and 5.3. Chapter 8. Sections 6.1-4.

Remarks

Chapter 8 should be read lightly. For the exam, you should know the strengths and weaknesses of the various ways of mixing SQL and programming, but not any specific syntax of any of these ways. In the project, though, you will be using one of these, namely JDBC.

Lecture May 2 (Expected Contents)

More on normalization theory.

Reading

Kifer, Bernstein, and Lewis: Sections 6.5-8.

Exercises May 3

Exercises 5.15, 5.20, 5.21, 8.1, 8.2, 8.5, 8.7 (only part b), 8.9, 6.4, 6.8, 6.27, and 6.10 in Kifer, Bernstein, and Lewis.

Exercises May 10

Exercises 6.26, 6.22, 6.21, 6.18, 6.29, 6.30, and 6.19 in Kifer, Bernstein, and Lewis.