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.

Transcribed Image Text:

Catalog cataloglD (key) year CatalogProduct endDate .Price specialPrice Inventoryltem Productitem inventorylD [key) ize productlD (key)1 vendor 0..color Shipper options shipperlD (key) name address contactName price backorderStatus quantity price reason 0..1 ackingNo [key) imeSent imeArrived Order orderlD orderDate shipping&Handling grandTotal Order Transaction accountNo (key) 0.. priorityCode 1 date transactionType dayPhone paymentMethod WebOrder MailOrder callStartTime