Thursday, August 20, 2015

1-1-1 ternary relationship



1-1-1 ternary relationship (one-to-one-to-one ternary relationship)


The above ER diagram has cardinality ratio 1:1:1. Let us assume 1 department has 1 manager and 1 secretary. Now 1 department with 1 manager works with 1 secretary. 1 department with 1 secretary works with 1 manager. 1 manager together with 1 secretary works in 1 department.












 

No comments:

Post a Comment