type of cardinality relationship
example of many-to-many relationship
An Author can write several Books, and a Book can be written by several Authors.
example of one-to-one relationship
One person has one passport.
one-to-many relationship
each row in the related table can be related to many rows in the relating table
example of one-to-many relationship
one mother can have many child, each child will only have one biological mother
one-to-one relationship
refers to relationships of two items in which one can only belong with the other.
many-to-many relationship
type of cardinality that refers to the relationship between two entities A and B in which A may contain a parent instance for which there are many children in B and vice versa.