Custom Search

Thursday 13 September 2012

Define Relationship & Relationship Set in Database Management System(DBMS)

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 



=>>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

Laptops