Relationship Types of degree higher than 2

Relationship types of degree higher than 2 in database.

1. 1 / 13
Relationship Types of Degree
Higher than Two
Aadesh Shrestha

2. 2 / 13
Degree of a relationship type
●number of participating entity types ( (binary,
ternary, . . . ))
● a relationship type of degree two - binary
● a relationship type of degree three – ternary
●n-nary

3. 3 / 13
Binary Relationship
●two entities are involved in binary relationship.
●example "some employees are married to other
employees".

4. 4 / 13
Ternary Relationship
●three entities are in involved in ternary relationship

5. 5 / 13
… ternary relationship
● Ternary or n-ary relationships can be decomposed
into two or more binary relationships.

6. 6 / 13
Constraint on Relationship Types
●Limit the number of possible combinations
of entities thatmay participate in a relationship
set
●Two types of constraint:
–Cardinality ratio
–Participation constraint

7. 7 / 13
… Cardinality ratio
●cardinality ratio must be one of the following
types

8. 8 / 13
… Cardinality ratio

9. 9 / 13
… Cardinality ratio

10. 10 / 13
… Cardinality ratio

11. 11 / 13
Participation Constraint
●participation constraint defines the number of times
an object in an object class can participate in a
connected relationship set
●every connection of a relationship set must have a
participation constraint.

12. 12 / 13
Participation Constraint

13. 13 / 13
Thank you
Reference Papers
●http://web.cs.ucdavis.edu/~green/courses/ecs165a-w11/2-er.pdf
●http://osm7.cs.byu.edu/OSA/participConst.html
●http://www.webmaster-forums.net/web-programming-and-application-development/what-degree-relationship-database