Question: undefined Suppose there is a superclass G specialized into two subclasses: 51 and 52 in an EER schema. The specialization is partial and disjoint. G

undefined Suppose there is a superclass G specialized into two subclasses: 51undefined

Suppose there is a superclass G specialized into two subclasses: 51 and 52 in an EER schema. The specialization is partial and disjoint. G has three attributes, 51 and 52 have each 10 attributes. Which of the following is a reasonable way to translate this structure into the Relational Model? A. Translate only subclasses S1 and 52 into relations Rsi and Rs2. And add all the attributes of G to both Rs1 and Rs2- OB. Translate all three classes into a single relation R with all attributes of G, 51, and 52. c. Translate each class into a separate relation, i.e. Ginto RG, S1 into Rs1, and S2 into Rs2. With the appropriate definition of foreign keys. OD. All of the above O E. None of the above

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!