Jump to content

Cardinality (data modeling)

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Oleg Alexandrov (talk | contribs) at 19:47, 2 December 2006 (fork from Cardinality). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

In computer engineering, the cardinality of one data table with respect to another data table is a critical aspect of database design. If a hospital designs it own database and has separate data tables keeping track of doctors and patients, there might be a many-to-one relationship between 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.