wiz-icon
MyQuestionIcon
MyQuestionIcon
10
You visited us 10 times! Enjoying our articles? Unlock Full Access!
Question

What do you understand by relationship type? How is it different from relationship instance and relationship set?

Open in App
Solution

Whenever entities from different entity types are related to one another in a particular manner, they constitute a relationship type. The relationship prepared by between the two entity types vouchers and employees associates each voucher with the employee who prepared it.
Similarly, the relationship authorized by between the two entity types vouchers and employees associates each voucher with the employee who authorizes it.
The degree of a relationship type is the number of participating entity types. A relationship type of degree two is called binary and that of degree three is caller ternary.

A VOUCHER (entity), Authorized by (relationship) a) and EMPLOYEES (entity) together signify a binary relationship. A SUPPLIER (entity) SUPPLY (relationship) PARTS (entity) to PROJECT (entity) signify a ternary relationship because three entities, namely supplier parts and projects are participating in a supply relationship in any transaction.
Relationship present at particular instance of time is known as relationship instance
Relationship sets
1:1 (one to one relationship set)
1:M (one to any relationship)
M:M (many to many relationship set)

flag
Suggest Corrections
thumbs-up
0
Join BYJU'S Learning Program
similar_icon
Related Videos
thumbnail
lock
Types of Functions
MATHEMATICS
Watch in App
Join BYJU'S Learning Program
CrossIcon