How to show composite keys in Chen E-R Diagram
You can underline the text of each attribute that is involved in the primary key:
Note that an associative entity set normally has a composite key. Introducing a surrogate key changes it into a regular entity set with its own identity. Associative entity sets are really just relationships which are the subjects of further relationships, and relationships are identified by the entity keys of the related entity sets.
NoChance
Not much to say about myself, except that I am very eager to learn and help other with the limited knowledge I sometimes have. When I post an answer, I am trying to help others. I also expect to be corrected if my answer is wrong so that I could learn and polish my knowledge. I would like to thank the publishers of this site and every one who help me learn more.
Updated on June 14, 2022Comments
-
NoChance almost 2 years
How to show composite keys in Chen E-R Diagram? I have not used this notation and I really don't like it. Any references would suffice, as I have excellent understanding of data modeling concepts (what a brag!). Note: I am aware of the symbol for associative entity, in such a symbol, one may have an auto-increment key as the PK, but then again, one may use the 2 FKs. In the later case, the PK would be composite. I don't know how to show it since Chen attribute symbol is an oval for each attribute. Thanks.