Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

Question

Quizplus · Accepted Answer

Cardinality is a fundamental concept in database design and refers to the relationship between tables. It describes the number of instances in one table that can be associated with a single instance in a related table. For example, in a one-to-many relationship between a customer table and an order table, the cardinality would be one-to-many, meaning that each customer can have multiple orders associated with them.

Cardinality Describes the Number of Possible Occurrences in One Table