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.



$1.99
Sales0
Views421
Comments
  • CreatedJanuary 28, 2011
  • Files Included
Post your question
5000