The following exercises are based on the TAL Distributors database as designed in Example 1 in this chapter. In each exercise, represent your answer in DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram.
1. Indicate the changes you need to make to the design of the TAL Distributors database to support the following situation. A customer is not necessarily represented by a single rep but can be represented by several reps. 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.
2. Indicate the changes you need to make to the design of the TAL Distributors database to support the following situation. There is no relationship between customers and reps. When a customer places an order, it may be through any rep. On the order, identify both the customer placing the order and the rep responsible for the order.
3. Indicate the changes you need to make to the design of the TAL Distributors database in the event User View 3 requirements are changed as follows: For an item, store the item’s number, description, category, and price. In addition, for each storehouse in which the item is located, store the number of the storehouse, description of the storehouse, and number of units of the item stored in the storehouse.
4. Indicate the changes you need to make to the TAL Distributors database design to support the following situation. The region where customers are located is divided into territories. For each territory, store the territory number (a unique identifier) and territory name. Each rep is assigned to a single territory. Each customer is also assigned to a single territory, but the territory must be the same as the territory to which the customer’s rep is assigned.
5. Indicate the changes you need to make to the TAL Distributors database design to support the following situation. The region where customers are located is divided into territories. For each territory, store the territory number (a unique identifier) and territory name. Each rep is assigned to a single territory. Each customer is also assigned to a single territory, which may not be the same as the territory to which the customer’s rep is assigned.
6. Indicate the changes you need to make to the TAL Distributors database design to support the following situation. The customer address may or may not be the same as the ship to address on the customer’s invoice.