The number of the instances of one entity that are related to another entity. Examples: Zero to one, one-to-one, one-to-many, many-to-many, 2 to 9. Also referred to as "multiplicity".

The specific type of relationship that exists between two tables. If a single record in the first table is related to only one record in the second table a one-to-one relationship exists. If a single record in the first table can be related to one or more records in the second table, a one-to-many relationship exists. Or, if a single record in the first table can be related to one or more records in the second table, and a single record in the second table can be related to one or more records in the first table, a many-to-many relationship exists. Hernandez, 1997. ()

The range of numbers a data item can count.

The count of objects in a set of instances of a type.

Table: The number of rows in the table Relationship: A restriction on the number of instances of the dependent entity which appear for each instance of the independent entity. Example: 1:0-M. "1" and "0-M" are cardinality statements.

defines the relationship between entities, 1:1, 1:M, M:M. The minimum and maximum values for the entity occurrences that occur in a related table.

A business rule specifying how many times (minimum and maximum) and entity can be related to another entity in a given relationship.

From an OLTP perspective, this refers to the number of rows in a table. From a data warehousing perspective, this typically refers to the number of distinct values in a column. For most data warehouse DBAs, a more important issue is the degree of cardinality. See Also: degree of cardinality

the number of elements in an extended compound element

The Cardinality of a relationship represents the number of occurrences between entities. An Entity with a cardinality of one is called a parent entity, and an entity with a cardinality of one or more is called a child entity.

The number of elements in a set. Contrast: multiplicity.

no of unique rows divided by total no of columns

Can refer to either table cardinality (the number of rows in a table) or column cardinality (the number of distinct values in a column of a table).

"Constraint on the number of successors on a relationship. The cardinality for the relationship biological mother is 1; for biological child it is 0 or greater."

Principle that the last number in a set of counted numbers refers to the number of items in that set.

The number of rows in a table or the number of indexed entries in a defined .

In mathematics, the cardinality of a set is a measure of the "number of elements of the set". There are two approaches to cardinality – one which compares sets directly using bijections and injections, and another which uses cardinal numbers.

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.