Indicate the changes you need to make to the design of the Premiere Products database to support the following situation

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.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Benefits of our college essay writing service

  • 80+ disciplines

    Buy an essay in any subject you find difficult—we’ll have a specialist in it ready

  • 4-hour deadlines

    Ask for help with your most urgent short tasks—we can complete them in 4 hours!

  • Free revision

    Get your paper revised for free if it doesn’t meet your instructions.

  • 24/7 support

    Contact us anytime if you need help with your essay

  • Custom formatting

    APA, MLA, Chicago—we can use any formatting style you need.

  • Plagiarism check

    Get a paper that’s fully original and checked for plagiarism

What the numbers say?

  • 527
    writers active
  • 9.5 out of 10
    current average quality score
  • 98.40%
    of orders delivered on time
error: