Assignment:
1. The Universal Product Code (UPC) is a bar-coded number that uniquely identifies many products sold in the United States. For example, all printed
copies of this textbook sold in the United States have the same UPC bar code on the back cover. Now consider how the design of the RMO database might
change if all items sold by RMO were required by law to carry a permanently attached UPC (e.g., on a label sewn into a garment or on a radio frequency ID
tag attached to a product). How might the RMO relational database schema change under this requirement?
2. Assume that RMO will begin asking a random sample of customers who order by telephone about purchases made from competitors. RMO will give customers a
15 percent discount on their current order in exchange for answering a few questions. To store and use this information, RMO will add two new classes and
three new associations to the class diagram. The new classes are Competitor and ProductCategory. Competitor has a one-to-many association with Product
Category, and the existing Customer class also has a one-to-many association with Product Category. 2Competitor has a single attribute called Name.
ProductCategory has four attributes: Description, DollarAmountPurchased, MonthPurchased, and YearPurchased. Revise the relational database schema shown
in Figure 12-10 to include the new classes and associations. All tables must be in 3NF.