Premiere Products Exercise Chapter 6 | Complete Solution
- ExpertT
- Rating : 109
- Grade : A+
- Questions : 1
- Solutions : 1026
- Blog : 0
- Earned : $53187.54
Premiere Products Exercises
The following exercises are based on the Premiere Products 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 Premiere Products database to support the following situation. A customer is not necessarily represented by a single sales rep 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 one of the collection of sales reps who represents the customer.
2. Indicate the changes you need to make to the design of the Premiere Products database to support the following situation. There is no relationship between customers and sales reps. When a customer places an order, it may be through any sales rep. On the order, identify both the customer placing the order and the sales rep responsible for the order.
3. Indicate the changes you need to make to the design of the Premiere Products database in the event User View 3 requirements are changed as follows; For a part, store the part’s number, description, item class, and price. In addition, for each warehouse in which the part is located, store the number of the warehouse, description of the warehouse, and number of units of the part stored in the warehouse.
4. Indicate the changes you need to make to the Premiere Products 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 sales 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 sales rep is assigned.
5. Indicate the changes you need to make to the Premiere Products 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 sales 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 sales rep is assigned.
[Solved] Premiere Products Exercise Chapter 6 | Complete Solution
- This Solution has been Purchased 15 time
- Average Rating for this solution is A+
- Submitted On 28 Feb, 2015 08:27:33
- ExpertT
- Rating : 109
- Grade : A+
- Questions : 1
- Solutions : 1026
- Blog : 0
- Earned : $53187.54
To make it work, we will remove the constraint w...
Premiere Products Exercise Chapter 5 | Complete Solution
The following exercises are based on the Premiere Products database.
1. Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functio...
Premiere Products Exercise Chapter 4 | First 10 questions solved
This Tutorial is rated A+ previously,if you have any questions regarding this tutorial than you can contact me.
...Premiere Products Exercise Chapter 2 | Complete Solution
In the following exercises, you will use the data in the Premiere Products database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the Premiere Products database so you will still ha...
Premiere Products Exercise Chapter 1 | Complete Solution
Communication time = access delay +(data volume / transmission rate)
Communication time = 2.5 + (5000 * 1000 /50000)
= 2.5 + (5000000/50000)
= 2.5 + (100) =&nbs...
Premiere Products Exercise Chapter 9 | Complete Solution
1. Fragment the Customer table so that customers of rep 20 form a fragment named CustomerRep20, customersof rep 35 form a fragment named CustomerRep35, and customers of rep 65 form a fragment named CustomerRep65. (Include ...