Hello, I am studying out of Phillip Pratt\'s \"A Guide to MySql\" and am stuck o

Question

Hello, I am studying out of Phillip Pratt's "A Guide to MySql" and am stuck on a problem in the second chapter.

The problem states:

Indicate the changes (using the shorthand representation) that you would need to make the current deign of the Premiere Products database to support the following requirements.

A Customer is not necessarily represented by a single sales rep, but can be represented by several sales reps. When a customer places an order, the sales rep who gets the commission on the order must be in the collection of sales reps who represent the customer.

The database is currently designed as below (note that the underlined fields are the primary keys):

Rep (Rep_Num, Last_Name, First_Name, Street, City, State, Zip, Commission, Rate)

Customer (Customer_Num, Customer_Name, Street, City, State, Zip, Balance, Credit_Limit, Rep_Num)

Orders (Order_Num, Order_Date, Representation_Id)

Part (Part_Num, Description, On_Hand, Class, Warehouse, Price)

Order_Line (Order_Num, Part_Num, Num_Ordered, Quoted_Price)

Explanation / Answer

Rep (**Rep_Num**, Last_Name, First_Name, Street, City, State, Zip, Commission, Rate) Customer (**Customer_Num**, Customer_Name, Street, City, State, Zip, Balance, Credit_Limit) Represents(**Represents_Id**, Customer_Num, Rep_Num) Orders (**Order_Num**, Order_Date, Represents_Num) Part (**Part_Num**, Description, On_Hand, Class, Warehouse, Price) Order_Line (**Order_Num**, **Part_Num**, Num_Ordered, Quoted_Price)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.