ternary relationship as a three legs table

Discipline

Databases

Form

Database Analogies

Attribution — Origin / Source

Collected by Giovanna Guerrini — Lecture Notes

Topic

Conceptual modeling

Domain

Anything else

Conceptual Advantage

helps user understanding ternary (and n-ary) relationships as sets of triples (n-uples)

Mapping

SymbolConcept
relationship instance table
entity instance leg

Draws Attention To

An instance of the entity might or might not participate to the relationship A instance of the relationship always requires one instance of each related entity

Details

Text

A ternary relationship is like a three legs table: it cannot stand with just two legs

Comments or Feedback?

Do you have feedback on this notional machine? Did you find a mistake, or do you have a request for improvement? You can create an Issue on GitHub, where the description is hosted. This way we can see your feedback and address it.

For this, you need a GitHub account. Then follow this link to see the source file of this page. In there, click the ... left of the highlighted line, then pick "Reference in a new issue".

Create an Issue on GitHub