0 votes
in Sql by
What is degree and cardinality in SQL?

1 Answer

0 votes
by

Degree in SQL could be defined as the total number of entities that are involved in the relationship and it is usually 2 (binary relationship), and there is a possibility of Unary, and higher degree relationships can exist.

Whereas, Cardinality in SQL, could be defined as the number of entities that are involved in a relationship. Basically, there are 3 types of Cardinality for binary relationships; one-to-one (1:1), one-to-many (1:n), and many-to-many (n:x).

Related questions

0 votes
asked Feb 2, 2021 in Sql by SakshiSharma
0 votes
asked Jul 7, 2020 in Sql by Robindeniel
...