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.
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 ...
Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
