Indicate the changes (using the shorthand representation) that you would need to
ID: 3549329 • Letter: I
Question
Indicate the changes (using the shorthand representation) that you would need to make to the original Premiere Products database design to support the following requirements. There is no relationship between customers and sales reps. When a customer places an order, any sales rep can process the order. On the order, you need to identify both the customer placing the order and the sales rep responsible for the order. Draw an E-R diagram for the new design.
Complete shorthand representation for the Premiere Products database is:
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, CUSTOMER_NUM)
ORDER_LINE (**ORDER_NUM**, **PART_NUM**, NUM_ORDERED, QUOTED_PRICE)
PART (**PART_NUM**, DESCRIPTION, ON_HAND, CLASS, WAREHOUSE, PRICE)
Explanation / Answer
Check http://academicservices.us/ can help, give them your budget