Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
278 views
in Structuring Database for Accounting by (15.2k points)

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

Please log in or register to answer this question.

1 Answer

0 votes
by (15.7k points)

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 employees who prepared it. 

Similarly, the relationship authorised by between the two entity types, vouchers and employees associate each voucher with the employee who authorises 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 called ternary. AVOUCHER (entity), Authorised by (relationship) and EMPLOYEES (entity) together signify a binary relationship.

ASUPPLIER (entity) SUPPLY (relationship) PARTS (entity) to PROJECT (entity) signify a ternary relationship because three entities, namely supplier, parts, and projects are participating in supply relationship in any transaction. Relationship sets

  • 1: 1 (one to one relationship set) 
  • 1: M (one to many relationship set) 
  • M: M (Many to many relationship set)

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...