A ternary relationship is an association among three entities. This type of relationship is required when binary relationships are not sufficient to accurately describe the semantics of the association.

What is ternary relationship explain with example?

A ternary relationship is when three entities participate in the relationship. For Example: The University might need to record which teachers taught which subjects in which courses.

How do you represent a ternary relationship?

Ternary Relationship: a ternary relationship is a relationship of degree three. That is, a relationship that contains three participating entities. Cardinalities for ternary relationships can take the form of 1:1:1, 1:1:M, 1:M:N or M:N:P.