5 Design
Please pay very close attention to the instructions. They give slight different guidance than the questions in the text.
Grade Details
GradeN/A Gradebook CommentsNone
Assignment Details
Open DateFeb 1, 2020 12:05 AMGraded?YesPoints Possible100.0Resubmissions Allowed?NoAttachments checked for originality?Yes
Assignment Instructions
Required Reading:
1. Pratt Concepts of Database Management — Chapter 6 – Database Design 2: Design Methodology
Assignment:
Incorporate the below letters and numbers to organize the submission – do not include the questions.
Part A)
Complete Review Question 18 at the end of Chapter 6 on page 225.
Descriptions / explanations must be in your owns words – include terms and phrases as needed. Techniques to ensure originality include the use of examples (other than those in the text) as well as following a quotation with your own explanation. (30%)
Part B)
Unable to provide a free E/R Modeling tool – therefore read the following instructions carefully. DO NOT SUBMIT DIAGRAMS
Complete the Premiere Products Exercises at the end of Chapter 6
For each task (label each task 1-5) in the exercise – provide the following:
The needed DBDL “and” an original explanation of the impact of the changes, for instance, how do the design changes allow the database to store the needed data or to represent any required relationships (10% for each task)
Writing Org/Clarity/Spelling/APA (20%)
Submit your response in a word compatible document.
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.
