Guidelines for representing complex cardinality constraints in binary and ternary relationships

  • Authors:

  • Dolores Cuadra;Paloma Martínez;Elena Castro;Harith Al-Jumaily

  • Affiliations:

  • Computer Science Department, Carlos III University of Madrid, Leganés, Spain 28911;Computer Science Department, Carlos III University of Madrid, Leganés, Spain 28911;Computer Science Department, Carlos III University of Madrid, Leganés, Spain 28911;Computer Science Department, Carlos III University of Madrid, Leganés, Spain 28911

  • Venue:
  • Software and Systems Modeling (SoSyM)
  • Year:
  • 2013

Quantified Score

Hi-index 0.00

Visualization

Abstract

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.