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

1 Expert Approved Answer
Step: 1 Unlock

The following tables must be added to the relational database schema Competitor CompetitorID Na... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1811_60b8c12183994_726474.pdf

180 KBs PDF File

Word file Icon

1811_60b8c12183994_726474.docx

120 KBs Word File

Students Have Also Explored These Related Systems Analysis Design Questions!