Question: 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

Indicate the changes (using the shorthand representation) that you would need

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

125 INVOICES INVOICE_LINE INVOICE_NUM INVOICE DATE CUST_ID INVOICE_NUM ITEM_ID QUANTITY QUOTED_PRICE 14216 11/15/2021 14216 CA75 3 $37.99 14219 11/15/2021 227 14219 AD72 2 $79.99 14222 11/16/2021 294 14219 DT12 $39.99 14224 11/16/2021 182 14222 LD14 1 $47.99 14228 11/18/2021 435 14224 KH81 4 $18.99 14231 11/18/2021 125 14228 FS42 1 $124.99 14233 11/18/2021 435 14228 PF19 1 $74.99 14237 11/19/2021 616 14231 UF39 2 $189.99 14233 KH81 1 $19.99 14233 QB92 $109.95 14233 WB49 4 $74.95 14237 LP73 $54.95 C ITEM ITEM_ID DESCRIPTION ON_HAND CATEGORY LOCATION AD72 Dog Feeding Station 12 DOG B BC33 Feathers Bird Cage (12x24x18) 10 BRD B CA75 Enclosed Cat Litter Station 15 CAT DT12 Dog Toy Gift Set 27 DOG B FM23 Fly Mask with Ears 41 HOR FS39 Folding Saddle Stand 12 HOR FS42 Aquarium (55 Gallon) 5 FSH KH81 Wild Bird Food (25 lb) 24 BRD LD14 Locking Small Dog Door 14 DOG A LP73 Large Pet Carrier 23 DOG B PF19 Pump & Filter Kit 5 FSH A QB92 Quilted Stable Blanket 32 HOR SP91 Small Pet Carrier 18 CAT B UF39 Underground Fence System 7 DOG A WB49 Insulated Water Bucket 34 HOR FIGURE 2-1 Sample data for Kim Tay Pet Supplies (Continued) PRICE $79.99 $79.99 $39.99 $39.99 $24.95 $39.99 $124.99 $19.99 $49.99 $59.99 $74.99 $119.99 $39.99 $199.99 $79.99 C

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

Figure 2 - 1 Sample Data for KimTay Pet Supplies SALES _ REP REP _ ID FIRST _ NAME LAST _ NAME ADDRESS CITY STATE POSTAL CELL _ PHONE COMMISSION RATE 0 5 Susan Garcia 4 2 Mountain Ln Cody WY 8 2 4 1...

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

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

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

What are the carryover periods for corporate net operating losses?

Frozen produces two types of toys names Slimline and Brainmaster. These product are packed in special designed packets as these are sold in the wholesale markets. Each product has to go through two...

The order of the precedence ( from high to low ) of the operators binary + , * , && , | | , ^ is: Group of answer choices ^ , | | , && , * , + && , | | , ^ , * , + * , + , && , | | , ^ * , + , ^ , &&...

*Picture of question below to make clear *Writing of question below to make more clear Estimating Bad Debts Expense and Reporting of Receivables At December 31, 2013, Sunil Company had a balance of...

4. EMC Corporation

5. Conduct a phone or personal interview with a training manager. Ask this person to discuss how training has changed in the past five years and how he or she believes it will change in the future.

6. Vanguard