Database Systems: Concepts, Design and Applications

6.3. Conversion of E-R Model into Relations

An E-R model can be converted to relations, in which each entity set and each relationship set is converted to a relation. Fig. 6.12 illustrates a conversion of E-R diagram into a set of relations.

Fig. 6.12. Conversion of E-R model to relations

[View full size image]

A separate relation represents each entity set and each relationship set. The attributes of the entities in the entity set become the attributes of the relation, which represents that entity set. The entity identifier becomes the key of the relation and each entity is represented by a tuple in the relation. Similarly, the attributes of ...