DM26, Fall 2005 - Weekly Note 2

Announcement

In the period September 26 through October 7, IMADA holds studies advising. It is mandatory for all students (except first year students) at IMADA-related studies to come to this studies advising (HA-Dat students of DM26 are exempted). You sign up at IMADA's secretaries' office (as soon as possible). Please have your picture taken before the advising by showing up at the department (at "værkstedet") between 12:00 and 14:00 on September 15, 19, or 22. Note that these dates are all prior to the advising period.

Lecture September 14

Finishing of E-R Model. Relational model, conversion from E-R model to relational model. (slides: pdf). Relational algebra (slides: pdf).

Reading

Ramakrishnan and Gehrke: Chapter 2 (you can skip 2.7 and 2.8), and sections 3.1, 3.2, 3.5, 4.1, and 4.2.

Remarks

At the lectures, I for conceptual clarity try to keep the relational model and SQL separated (unlike the book). I have therefore not discussed any SQL syntax yet, and you can read lightly the SQL syntax appearing in the sections above (some exercises are phrased using this SQL syntax, though).

Lecture September 21 (expected contents)

More on relational algebra. SQL.

Reading

Ramakrishnan and Gehrke: Section 4.2, Chapter 5, rest of Chapter 3 (you can skip 3.8).

Exercises September 21/23

Exercises 3.1, 3.4, 3.5, 3.6, 3.11, 3.12, 3.13, 3.15, 2.8, 3.18 in Ramakrishnan and Gehrke.