question archive I am using the book CONCEPTS OF DATABASE MANAGEMENT 8TH EDITIONThe following exercises are based on the TAL Distributors database as designed in Example 1 in this chapter
I am using the book CONCEPTS OF DATABASE MANAGEMENT 8TH EDITIONThe following exercises are based on the TAL Distributors database as designed in Example 1 in this chapter
Subject:Computer SciencePrice: Bought3
I am using the book CONCEPTS OF DATABASE MANAGEMENT 8TH EDITIONThe following exercises are based on the TAL Distributors database as designed in Example 1 in this chapter. Ineach exercise, represent your answer in DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram.
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.
each question is suppost to have these two things:
| Q2 DBDL | ||
| Q2 ER Diagram | ||
| Q3 DBDL | ||
| Q3 ER Diagram | ||
| Q4 DBDL | ||
| Q4 ER Diagram | ||
| Q5 DBDL | ||
| Q5 ER Diagram |
