Sample Header Ad - 728x90

Understanding many-to-many ternary relationship sets

0 votes
1 answer
651 views
I am new to entity-relationship diagrams. I'm a bit confused when it comes to interpreting ternary relationship sets such as this: enter image description here Does this signify that every relationship instance of Party will have one fighter, one mage, and one healer? If we were simply dealing with binary relationship sets without key or total constraints, every instance of the relationship would be linked to an entity from each entity set. But in the case above, isn't it possible to not have one instance from a particular entity set? E.g. if the Party instance only had one fighter and one healer (and no mage)?
Asked by Yash Chowdhary (111 rep)
Sep 13, 2019, 09:13 AM
Last activity: Mar 21, 2025, 01:05 PM