Assume that RMO is developing its database using object-oriented methods. Assume further that the database designers want to make some changes to the class diagram in Figure (a). Specifically, they want to make Product Item an abstract parent class from which more specific product classes are specialized. Three specialized classes will be added: Clothing Item, Equipment Item, and Other Item. Clothing Item will add the attribute color, and that same attribute will be removed from the Inventory Item class. Equipment Item will also add an attribute called color but will not have an attribute called gender. Other Item will have both the color and gender attributes. Revise the relational database schema in Figure (b) to store the new Product Item generalization hierarchy. Use a separate table for each of the specializedclasses.

  • CreatedDecember 27, 2012
  • Files Included
Post your question