Cardinality_(data_modeling)

In data modeling, the cardinality of one data table with respect to another data table is a critical aspect of database design. For example, in a database designed to keep track of hospital records there may be separate data tables keeping track of doctors and patients, with a many-to-one relationship between the records in the doctor table and records in the patient table. Whether data tables are related as many-to-many, many-to-one, or one-to-one is said to be the cardinality of a given database design.

A crow\'s foot shows a one-to-many relationship, single line is a one-to-one relationship.

External links

• Data Model Cardinality

This database-related article is a stub. You can help Wikipedia by expanding it.

This article is licensed under the GNU Free Documentation License. It uses material from Wikipedia