'Difference between a ternary relationship and an aggregation in er modelling?

How to recognize if a relationship is ternary or an aggregation?

For example: A player gets an award in a match he plays. If the entities are player, match and award, is this a ternary or an aggregation?

entity-relationship


Solution 1:[1]

The answer was given to me by a lecturer, it's a ternary relationship because there are 3 contributing entities involved.

Aggregation is, on the other hand, where you aggregate two entities into a single entity and create another relationship to support m:m scenarios.

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Jolly Good

Related Questions