O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required