The Relational Model

lab notes

In the previous lab we discussed the Conceptual Database Design Phase and the ER Diagram. Today we will mainly discuss how to convert an ER model into the Relational model of a specific database.

Outline

1) Introduction – discuss briefly the relational model

2) Logical Database Design (Steps involved ER model -> Relational model).

3) A glance at Views

4) Putting it all together – An example.

Exercise 1 Use the entity relational model created for Exercise 2.5 in the previous lab. Here it is a solution for this exercise. Construct a corresponding relational schema and database in Postgres.