Question: Please use the attatched image for reference to answer this question: Indicate the changes ( using the shorthand representation ) that you would need to

Please use the attatched image for reference to answer this question:

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 customers 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.

Please use the attatched image for reference to answer this question:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Use the data shown in figure 2-1 to answer. 1. Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design (see Figure...

Q1. Indicate 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. A...

Assignment 0 2 You need to change table design and write the new table design in shorthand representations. No need to write SQL commands or table data. Questions: KimTay Pet Supplies 1 . Indicate...

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...

Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 2-1. pres - Open a new MicrosoftQ Word document and answer the following question. - Save the file on your...

Can someone please help me figure these out? These questions are from A Guide to SQL. ISBN: 978-1-305-89739-7 Exercises TAL Distributors Answer each of the following questions using the TAL...

Open a new Microsoft Word document and answer the following question. Save the file on your computer with your last name in the file name. (Example: Case_Exercise_1 _Jones.doc) Click the Choose File...

Open a new Microsoft ( 2 ) Word document and answer the following question. Save the file on your computer with your last name in the file name. ( Example: Case _ Exercise _ 1 _ Jones.doc ) Click the...

CREATE TABLE SALES_REP ( REP_ID CHAR(2) PRIMARY KEY, FIRST_NAME VARCHAR(20), LAST_NAME VARCHAR(20), ADDRESS VARCHAR(20), CITY VARCHAR(15), STATE CHAR(2), POSTAL CHAR(5), CELL_PHONE CHAR(12),...

Imagine that a funder asks your organization to support a deworming campaign to all public primary schools in the sub-district of Mormugao in the state of Goa, India. The project period is March 1 to...

Construct a two-way table with 60 women and 80 men in which both groups show equal percentages of right-handedness.

Cooperton Miring just announced it will cut its dividend from $ 3 8 7 to $ 2 2 8 per share and use the extra funds to expand. Prior to the announcement, Cooperfon's dividends were expected lo grow at...

Suppose that the profit obtained from the sale of x fish -fry dinners is given by P(x) = -0.025x + 8x-40. What is the marginal profit, in ' dollars from the sale of the 101st fish-fry dinner? Write...