Relationship Sets In DBMS
A Relationship is an association among several entities for example a relationship that associate customer Deepak with Loan L-17. This relationship specifies that 'Deepak' is a customer with loan number 'L-17'.
A relationship set: It is a set of relationship of the same type. Mathematical relation on
n>=2 (possibly non distinct) entity sets.
If E1,E2,.....En are entity sets the a relationship set R is a subset of
{ (e1,e2,......en)|e1E1,e2E2,......enEn}
where (e1,e2,......en) is a relationship
Let 'Customer' and 'Loan' entity sets defines the relationship ' set Borrow' to denote the association between customer and bank loans.