Ques:- Define Relationship & Relationship Set in Database Management System(DBMS)
Answer: A relationship is an association among several entities
Example:
Hayes
customer entity
depositor
relationship set
A-102
account entity
A relationship set is a mathematical relation among n >=2 entities,each taken from entity sets
{(e1, e2, … en) | e1 belongs to E1, e2 belongs to E2, …, en belongs to En}
where (e1, e2, …, en) is a relationship
Example:
(Hayes, A-102) belongs to depositor
Answer: A relationship is an association among several entities
Example:
Hayes
customer entity
depositor
relationship set
A-102
account entity
A relationship set is a mathematical relation among n >=2 entities,each taken from entity sets
{(e1, e2, … en) | e1 belongs to E1, e2 belongs to E2, …, en belongs to En}
where (e1, e2, …, en) is a relationship
Example:
(Hayes, A-102) belongs to depositor
=>>An attribute can also be property of a relationship set.
=>> For instance, the depositor relationship set between entity sets
customer and account may have the attribute access-date
No comments:
Post a Comment