DbM TAL Distributors Ch. 6 (Page 220)
Use DBDL notation for your answers. Draw one E-R diagram using your choice of drawing, copy or snip and add to Word document
Rep (RepNum, LastName, FirstName, Street, City, State, PostalCode, Commision, Rate)
Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum(FK))
Orders (OrderNum, OrderDate, CustomerNum(FK))
OrderLine (OrderNum(FK), ItemNum(FK), NumOrdered, QuotedPrice) – only identifies through oters and item entity
Item (ItemNum, Description, OnHand, Category, Storehouse, Price)
Question 1. Indicate the changes you need to make to the design of the TAL Distributors database to support the following situation: a. A customer is not necessarily represented by a single rep but can be represented by several reps b. When a customer places an order, the rep who gets the commission on the order must be one in the collection of reps who represents the customer
Rep (RepNum, LastName, FirstName, Street, City, State, PostalCode, Commision, Rate)
Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit)
CustomerRep (RepNum (FK), CustomerNum(FK))
Orders (OrderNum, OrderDate, CustomerNum(FK))
OrderLine (OrderNum(FK), ItemNum(FK), NumOrdered, QuotedPrice)
Item (ItemNum, Description, OnHand, Category, Storehouse, Price)

Question 2. Indicate the changes you need to make to the design of the TAL Distributors database to support the following situation: a. There is no relationship between customers and reps b. When a customer places an order it may be through any rep c. On the order, identify both the customer placing the order and the rep responsible for the order

Rep (RepNum, LastName, FirstName, Street, City, State, PostalCode, Commision, Rate)
Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance,