5 design | Information Systems homework help

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 Your Essay Price
(550 words)

Approximate price: $22

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)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more