Week 08

Announcements

After this week's lecture 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.

Exercise Tuesday (21.02.2012)

Exercises 3.2.1, 3.3.1.a, 3.4.1d, 3.5.3

Lecture Wednesday (22.02.2012)

The sixth lecture will introduce 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 Thursday (23.02.2012)

Exercises 4.1.[1,2] (including CPR number), 4.2.1, 4.3.1.b, 4.6.1