Reference no: EM1372279
"The following exercises are based on the Premiere Products database as designed in Example 1. 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 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 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 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.
|
Describe what is meant by a dominant strategy
: Describe what is meant by a dominant strategy. Given payoff matrix above, does each firm have a dominant strategy. Under what circumstances would re be no dominant strategy for one or both firms.
|
|
Conclude the force of friction between the wooden block
: A baseball is thrown horizontally at the catcher, who is 60.0 ft away. It is thrown with a velocity of 87.5 mph. How far does the baseball fall during this pitch.
|
|
Describe the history of social security
: Describe the history of social security, its effectiveness at inception compared to the present, and the future of Social Security. In addition, apply your knowledge and opinion to this question: Would you try to ensure the future of Social Securi..
|
|
What if net foreign debt were percent of gdp
: What would be drain on U.S. GDP (as a percentage) from paying interest on net foreign debt. What if net foreign debt were 100 percent of GDP? Size of its foreign debt.
|
|
Changes require to make-premiere products database
: Point out the changes you require to make to Premiere Products database to support following situation: A customer is not necessarily represented by a single sales rep but can be represented by several reps.
|
|
History-success of social security
: Describe the history of social security, its effectiveness at inception compared to the present, and the future of Social Security. In addition, apply your knowledge and opinion to this question: Would you try to ensure the future of Social Securi..
|
|
Calculating marginal revenue and optimum price
: Suppose you are the manager of a company that produces output in two plants. The demand for your company's product is P = 78 - 15Q, where Q = Q1 + Q2.
|
|
Why they violate human right to water.
: People should control water, not corporations. Water is a common resource and we all have an equal right to this precious resource and a responsibility to protect it. Pre-Paid Water Meters: Why they violate human right to water.
|
|
How long would it take to fill the tank
: A force does +130J of work while it acts on a moving object and its direction is in the same direction as the object's displacement. How much work does this force do as the angle between it and the object's displacement is 56°.
|