Cardinality in DBMS

  • Cardinality in DBMS is a vital piece of information about the relationship between two entities.

Cardinality of a Relationship

The cardinality of a relationship can be defined as the number of times an tuple of an entity set participates in a relationship. Cardinality shows how the entities are connected to each other.

There are two types of Cardinality Constraint

  • Cardinality Constraint/Mapping Constraint - link
  • Participation Constraint- link