Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 2-1. por Indieate the changes (using the shorthand representation) that

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 2-1. por Indieate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design (see Figure 2-1) to support the following requirements. customer is not necessarily represented by a single sales rep, but they can be represented by several sales reps. When a customer places an order, the sales rep who gets the commission on the invoice must be in the collection of sales reps who represent the customer. - Open a new Microsofty Word document and answer the following question. - Save the file on your compter with your last name in the file name._(Example: Case_Exercise_1 _Jones.doc) - Click the Choose File button to find and select your saved document. Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design to support the following requirements. There is no relationship between ustomers and sales reps. When a customer places an order, any sales rep can process the order and create the invoice. On the invoice, you need to identify both the customer placing the order and the sales rep responsible for the invoice. Draw an E-R diagram for the new design

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

WHO HAS OVERALL RESPONSABILITY FOR MANAGING THE ON SCENE INCIDENT

Answered: 1 week ago

Question

Identify four applications of HRM to healthcare organizations.

Answered: 1 week ago