join between one to one ,one to many,many to one or many to 
many

Cardinality is a property of a join that describes how many 
rows in one table match rows in another table. Cardinality 
is expressed as the minimum and maximum number of rows in a 
column at one end of a join, that have matching rows in the 
column at the other end of the join. The minimum and the 
maximum number of row matches can be equal to 0, 1, or N.

Cardinality is a property of a join that describes how many 
rows in one table match rows in another table. 

Cardinality is expressed as the minimum and maximum number 
of rows in a column at one end of a join, that have 
matching rows in the column at the other end of the join. 

The minimum and the maximum number of row matches can be 
equal to 0, 1, or N.