DM505, Spring 2006, 4th Quarter - Weekly Note 6

This week, there will be exercises Monday and Thursday, and lectures Wednesday.

The lecture on May 11 was supposed to contain a brief introduction to accessing PostgreSQL from Java through the JDBC interface, but I unfortunately forgot this part. It will be covered at the lecture on May 17. In the last part of the project, the hard part is designing the SQL carrying out the requested queries, so you could choose to concentrate on this until May 17. If you want to start on the Java interface already now, you should read the note on using JDBC with PostgreSQL at IMADA, as well as the the JDBC documentation for PostgreSQL (Sections 31.1-4 are enough - and instead of reading 31.2, you may simply copy the first few lines in the Java code example on the note). Full details of the methods of the API can be found at the documentation for the java.sql package in Java.

Imada Announcements

There will be a "Pizza-Meeting" for all students of Imada on Thursday, May 18 at 16.00-18.30 in room U49. 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.

Instruktorater: Hjælp dine medstuderende, dygtiggør dig selv og få penge for det. Søg i dag! Der er normalt relativt få ansøgere, så det er ofte muligt at få et instruktorat, selv om man ikke er langt i studiet. Hvis du har spørgsmål, så henvend dig gerne på IMADA. Ansøgningsproceduren er beskrevet på www.jobs.sdu.dk. Hvis du allerede er ansat som instruktor i efteråret 2006, leverer du ansøgning om tildeling af timer ind på IMADA's sekretariat (se opslaget omkring bilag mm.). Ansøgningsfrist: 24. maj 2006 kl. 12:00.

Lecture May 10

End of functional dependencies and normal forms. Some left-over bits of SQL: general constraints, triggers, views.

Reading

Ramakrishnan and Gehrke: Rest of Sections 19.4-7. Sections 5.7-9 and 3.6.

Lecture May 11

Kontaktgruppe meeting: discussion of new tilvalg in Industrial Software Production. Start on index structures.

Reading

Ramakrishnan and Gehrke: Section 8.1-3 and Chapters 10.1-4.

Lecture May 17 (Expected contents)

End of index structures. Database application programming using JDBC. Stored procedures.

Reading

Rest of Chapters 8 and 10. Chapter 11. Sections 6.3 and 6.5. Note on using JDBC with PostgreSQL at IMADA.

Exercises May 15

Exercises 19.2, 19.5 (in question (a), just determine whether the relation is in BCNF), 19.13 (in 1., only answer the question on FD, not the question on MVD), 19.19, and 19.20 in Ramakrishnan and Gehrke.

Exercises 5.3 (only uneven numbered questions) in Ramakrishnan and Gehrke (try (some of) your solutions on the example data given on an earlier weekly note).

Exercises May 18

Exercises 8.1, 8.2 , 8.3, 8.9, 8.11, 10.1 (only questions 1, 2, and 3), 10.2 (only questions 1, 2, 3, and 4), and 10.3 in Ramakrishnan and Gehrke.