DM26, Fall 2006 - Weekly Note 4

Note: Friday, October 6, there will be no lectures due to the university Årsfest.

Lecture September 22

More on conversion from E-R model to the relational model. Data definition part of SQL. Start on relational algebra.

Reading

Ramakrishnan and Gehrke: Section 3.5, SQL contents of Sections 3.1-4, Section 3.7, Section 4.1 and Sections 4.2.1-3.

Lecture September 29 (expected contents)

More on relational algebra. Query part of SQL.

Reading

Ramakrishnan and Gehrke: Sections 4.2.4-6 and Sections 5.1-6.

Exercises October 2

Exercises 3.13, 3.15, 2.8, 3.18, 4.2, 4.3 (only questions 1 to 8, and only the relational algebra versions of the queries), and 4.4 in Ramakrishnan and Gehrke.