Question: Assume that RMO will begin by asking a random sample of customers who order by telephone about purchases made from competitors. RMO will give customers
Assume that RMO will begin by 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. A competitor has a one-to-many association with ProductCategory, and the existing Customer class also has a one-to-many association with ProductCategory. A competitor has a single attribute called Name. ProductCategory has four attributes: Description, dollar amount purchased, MonthPurchased, and year purchased. Revise the relational database schema shown in Figure 9-10 to include the new classes and associations. All tables must be in 3NF.
Step by Step Solution
3.40 Rating (162 Votes )
There are 3 Steps involved in it
The following tables must be added to the relational database schema Competitor CompetitorID Na... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1811_60b8c12183994_726474.pdf
180 KBs PDF File
1811_60b8c12183994_726474.docx
120 KBs Word File
