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


At the first lecture, we decided to use the Monday, Wednesday, and Thursday slots.

Monday, April 10, the slot will be moved due to overlap with first year project activities. The slot (an exercise class) will be

Monday, April 10, 12-14 in U47.

There will be two lectures and no exercise classes in the week after the Easter break.


Lecture April 3

Introduction to course. Introduction to Database Management Systems (slides: pdf).

Reading

Ramakrishnan and Gehrke: Chapter 1.

Remarks

Our introduction slides do not discuss exactly the same subjects as Chapter 1 (both sets of information are relevant).


Lecture April 4

The Entity-Relationship Model (slides: pdf).

Reading

Ramakrishnan and Gehrke: Chapter 2 (you can skip 2.7 and 2.8).


Lecture April 19 (expected contents)

Relational model. Transfer from E/R-model to relational model. Start on relational algebra.

Reading

Ramakrishnan and Gehrke: Chapter 3 (you may skip 3.8). Sections 4.1-2.

Remarks

In Chapter 3, the book mixes SQL and the relational model - it is important to know that these are really different concepts (the latter is a data model, the former a database query and managament language).


Lecture April 20 (expected contents)

More on relational algebra. SQL.

Reading

Ramakrishnan and Gehrke: Section 4.2, Chapter 5.


Exercises April 10

Exercises 1.4, 1.5, 1.6, 2.1, 2.2, 2.3, and 2.5 in Ramakrishnan and Gehrke.


Maintained by Rolf Fagerberg (rolf@imada.sdu.dk)