Answer the following questions

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.