Describe different types of relationship in a database management system

Relationship in a database management system: Consider a binary relationship set on entity sets A and B. There are four possible relationships in a database management system used in E-R diagram:-

(i) One-to-one: An entity in A is related to at most one entity in B and an entity in B is related to at most one entity in A.

(ii) One-to-many: An entity in A is related to any number (zero or more) of entities in B, but an entity in B is related to at most one entity in A.

(iii) Many-to-one: An entity in A is related to at most one entity in B, but an entity in B is related to any number of entities inA.

(iv) Many-to-many: An entity in A is related to any number of entities in B, but an entity in B is related to any number of entities in A.