Relationship: cardinality

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

Each dependent entity has 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

Each entity of the source entity type has one dependent entity.

m = C

Each entity of the source entity type has a maximum of one dependent entity.

m = N

Each entity of the source entity type has at least one dependent entity.

m = CN

Each entity of the source entity type can have any number of dependent entities.

The Structured Entity Relationship Model (SERM) does not allow m:n relationships (i.e. many-to-many relationships). Therefore, entity types in SERM can be arranged from left to right, from independent to dependent entity type.

The cardinality C:x (x = 1, C, CN, N) should be used only for relationships of the category 'referential'. (However, it can also be used for relationships of the category 'aggregating'.)

Hierarchical relationships do not allow this cardinality, since all dependent entities must refer to an entity of the source entity type.