14 Mar 4. Indicate the changes you
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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.