Week 09

Announcements

You should now know E/R diagrams, the relational data model and basic SQL. This means you have all the tools to start on Phase 1 of the course project. The project description will be available and announced during Week 09.

Lecture Monday (23.02.2009)

The sixth lecture will finish the introduction of the E/R model and the conversion to the relational model. Then we go back to SQL to explore constraints, triggers, and views.

Topics

E/R diagrams, E/R model -> relational model, Constraints, Triggers, Views

Reading

Chapters 4.3-4.6, Chapter 7, Chapters 8.[1,2,5]

Exercise Wednesday (25.02.2009)

Exercises 3.2.1, 3.3.1.a, 3.4.1d, 3.5.3
Exercises 4.1.[1,2] (including CPR number), 4.2.1, 4.3.1.b, 4.6.1

Exercise Thursday (26.02.2009)

Exercise 7.1.2, 7.2.2, 7.2.4, 7.4.1, 7.5.2, 8.2.2