Business analysis glossary
Cardinality
What it is
Cardinality describes how many instances of one entity can be related to instances of another, such as one to one, one to many or many to many. In an entity relationship diagram it is shown with notation such as crow's feet. It often also states whether the relationship is optional or mandatory.
Why it matters
Cardinality encodes real business rules, such as whether a customer can have more than one account or an order must have at least one item. Getting it wrong leads to databases that cannot store real situations or reports that double count. Analysts confirm cardinality with business stakeholders, not only with developers.
Example
At Lotus Lane Insurance, the analyst models that a policy can have many claims, but each claim belongs to exactly one policy. During review, the motor team explains that one accident can involve two of the same customer's policies. The model changes to allow a claim to link to more than one policy.