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

This week, there will be two lecture slots (May 14 and 16) and no exercise slot.

Next week, there will be one lecture slot (May 23) and two exercise slots (May 21 and 24).

The exercise slot May 10 was postponed (to May 21), since the required material had not been covered at the lectures.

There will be a "pizza-meeting" for all students of Imada on Monday, May 21 at 16.10-18.30 in room U47. At the meeting Imada will give general information on the Bachelor and Candidate studies, and specific information on the elective courses in Mathematics and Computer Science planned for the next semester. The meeting will end with a free pizza, beer, and soft drink session.

A number of instruktorater (teaching assistant jobs) are available at Imada. Deadline is May 31 at noon. More info at www.jobs.sdu.dk.

Lecture April 30

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

Reading

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

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

Start on normalization theory.

Reading

Kifer, Bernstein, and Lewis: Sections 6.1-4 (until page 202).

Lecture May 14

More on normalization theory.

Reading

Kifer, Bernstein, and Lewis: Sections 6.4, 6.5, 6.6.1, and 6.7.

Lecture May 16 (Expected Contents)

Even more on normalization theory. Start on indexes.

Reading

Kifer, Bernstein, and Lewis: Sections 6.6.2 and 6.8. Sections 9.1-5.

Exercises May 21

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