Relationship: Cardinality

Use

The cardinality (n : m) describes the relationship with respect to the number of dependent entities (entities of the target entity type) and referenced entities (entities of the source entity type) in the relationship.

The possible values for the left and right sides of the cardinality have the following significance:

• n = 1

  For each dependent entity there is exactly one referenced entity.

• n = C

  Dependent entities can exist that do not refer to an entity of the source entity type.

Referential relationships with the additional characteristic that a relationship can be defined or deleted for an entity irrespective of when the entity was created are referred to as temporarily referential.

• m = 1

  For each entity of the source entity type, there is exactly one dependent entity.

• m = C

  For each entity of the source entity type, there is a maximum of one dependent entity.

• m = N

  For each entity of the source entity type, there is at least one dependent entity.

• m = CN

  For each entity of the source entity type, there can be any number of dependent entities.