Cardinality (data modeling)

The cardinality of a join between two tables is the numerical relationship between rows of one table and rows in the other. Common cardinalities include one-to-one, one-to-many, and many-to-many. For example, consider a database of electronic health records. Such a database could contain tables like the following: * A doctor table with information about physicians. * A patient table for medical subjects undergoing treatment. * An encounter table with an entry for each hospital visit.

Cardinality (data modeling)

The cardinality of a join between two tables is the numerical relationship between rows of one table and rows in the other. Common cardinalities include one-to-one, one-to-many, and many-to-many. For example, consider a database of electronic health records. Such a database could contain tables like the following: * A doctor table with information about physicians. * A patient table for medical subjects undergoing treatment. * An encounter table with an entry for each hospital visit.