Explore BrainMass

Revise Relational Database Schema

13.4 Assume that GAP is developing its database using object-oriented methods. Assume further that the database designers want to make some changes to the class diagram on next page. Specifically, they want to make ProductItem an abstract parent class (entity) from which more specific product classes are specialized.

Three specialized classes will be added:

 ClothingItem - ClothingItem will add the attribute Color and that same attribute will be removed from the InventoryItem class.

 EquipmentItem - Equipment item will also add an attribute called Color but will not have an attribute called Gender.

 OtherItem - OtherItem will have both the Color and Gender attributes.


Solution Summary

Help to revise Relational Database Schema is achieved.