Guidelines for representing complex cardinality constraints in binary and ternary relationships Articles uri icon

publication date

  • October 2013

start page

  • 871

end page

  • 889


  • 4


  • 12

International Standard Serial Number (ISSN)

  • 1619-1366

Electronic International Standard Serial Number (EISSN)

  • 1619-1374


  • 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.


  • Computer Science


  • ternary associations; conceptual models; logical models; model transformations; database methodology