Question: Consider the representation of a ternary relationship using bina

Consider the representation of a ternary relationship using binary relationships as described in Section 2.4.3 (shown in Figure b)
a. Show a simple instance of E, A, B, C, RA, RB, and RC that cannot correspond to any instance of A, B, C, and R.
b. Modify the E-R diagram of Figure b to introduce constraints that will guarantee that any instance of E, A, B, C, RA, RB, and RC that satisfies the constraints will correspond to an instance of A, B, C, and R.
c. Modify the translation above to handle total participation constraints on the ternary relationship.
d. The above representation requires that we create a primary key attribute for E. Show how to treat E as a weak entity set so that a primary key attribute is notrequired.


View Solution:


Sale on SolutionInn
Sales0
Views439
Comments
  • CreatedJanuary 28, 2011
  • Files Included
Post your question
5000