question archive Answer each of the following questions using
Answer each of the following questions using
Subject:Computer SciencePrice: Bought3
Answer each of the following questions using. the TAL Distributors data shown in Figure 2-1. No computer. mrk is required. ' it. lr?oete the changes (using the shorthand representation) that you would need to make to .the original TAL Distributors database design (see Figure 2—1) to support the following requirements. A customer is not necessarily represented by a single sales rap, 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. 2. Indicate the changes (using the shorthand representation) that you would need to make to _ the original TAL Distributors database design to super! 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 responsble for the order.me an ER diagram for the new design. ' ' 3.. Indicate the changes (using the shorthand representation} that yrm would need to make to the original TAL Distributors database design in the event that the original Heanernent 3 is "changed as follows. For an item, store the item's number, description, category, and price. In addition, tor each storehouse in which the item is located store the number of ?re store _house. the description of the storehouse, and the number of units of the item stored in the storehouse Drew an E-B diagram for the new design.
