2
135kviews
Explain Total Participation and Partial Participation with example.
1 Answer
9
8.7kviews
written 8.5 years ago by | modified 3.5 years ago by |
1. Total Participation-
It specifies that each entity in the entity set must compulsorily participate in at least one relationship instance in that relationship set.That is why, it is also called as mandatory participation.
Total participation is represented using a double line between the entity set and relationship set.
Example-
Here,
Double line between the entity set “Student” and relationship set “Enrolled in” signifies total participation. It specifies that each student must be enrolled in at least one course.
2. Partial Participation-
- It specifies that each entity in the entity set may or may not participate in the relationship instance in that relationship set. That is why, it is also called as optional participation.
- Partial participation is represented using a single line between the entity set and relationship set.
Example-
Here,
Single line between the entity set “Course” and relationship set “Enrolled in” signifies partial participation. It specifies that there might exist some courses for which no enrollments are made.
ADD COMMENT
EDIT
Please log in to add an answer.