Guidelines for representing complex cardinality constraints in binary and ternary relationships

0
110

Authors: Dolores Cuadra, Elena Castro, Harith Al-Jumaily, Paloma Martínez

Tags: 2013, conceptual modeling

Ternary relationships represent the association among three entities whose constraints database designers do not always know how to manage. In other words, it is very difficult for the designer to detect, represent and add constraints in a ternary relationship according to the domain requirements. To remedy the shortcomings in capturing the semantics required for the representation of this kind of relationship, the present paper discusses a practical method to motivate the designer’s use of ternary relationships in a methodological framework. The method shows how to calculate cardinality constraints in binary and ternary relationships and to preserve the associated semantics until the implementation phase of the database development method.

Read the full paper here: http://www.sosym.org/