Assume that RMO will begin asking a random sample of
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 expand the ERD and class diagram with two new entities (classes) and three new relationships. The new entities (classes) are Competitor and Product Category. Competitor has a one-to-many relationship with Product Category, and the existing Customer entity (class) also has a one-to-many relationship with Product Category. Competitor has a single field (attribute) called Name. Product Category has four fields (attributes): Description, Dollar Amount Purchased, Month Purchased, and Year Purchased. Revise the relational database schema shown in Figure to include the new entities and relationships. All tables must be in3NF.
Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help