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.

relationship set

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.

relationship set by table

Facebook Likes