Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.

Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.

INVOICES INVOICE_NUM INVOICE_DATE CUST_ID 11/15/2021 125 11/15/2021 227 11/16/2021 294 11/16/2021 182 11/18/2021 435 11/18/2021 125 11/18/2021 435 11/19/2021 616 14216 14219 14222 14224 14228 14231 14233 14237 ITEM ITEM_ID DESCRIPTION AD72 Dog Feeding Station BC33 CA75 DT12 FM23 FS39 FS42 Feathers Bird Cage (12x24x18) Enclosed Cat Litter Station Dog Toy Gift Set Fly Mask with Ears Folding Saddle Stand Aquarium (55 Gallon) Wild Bird Food (25 lb) Locking Small Dog Door Large Pet Carrier Pump & Filter Kit Quilted Stable Blanket Small Pet Carrier INVOICE_LINE INVOICE_NUM ITEM_ID QUANTITY QUOTED_PRICE CA75 AD72 DT12 LD14 Underground Fence System 14216 14219 14219 14222 14224 14228 14228 14231 14233 14233 14233 14237 ON_HAND 12 10 15 27 41 12 5 24 14 23 5 32 KH81 FS42 PF19 UF39 KH81 QB92 WB49 LP73 18 7 34 CATEGORY DOG BRD CAT DOG HOR HOR FSH BRD DOG DOG FSH HOR CAT DOG HOR B B С B C C A C A B A 3 2 4 C B 1 KH81 LD14 LP73 PF19 QB92 SP91 UF39 WB49 Insulated Water Bucket FIGURE 2-1 Sample data for Kim Tay Pet Supplies (Continued) A C 4 1 LOCATION 1 2 1 4 4 3 $37.99 $79.99 $39.99 $47.99 $18.99 $124.99 $74.99 $189.99 $19.99 $109.95 $74.95 $54.95 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
Transcribed Image Text:INVOICES INVOICE_NUM INVOICE_DATE CUST_ID 11/15/2021 125 11/15/2021 227 11/16/2021 294 11/16/2021 182 11/18/2021 435 11/18/2021 125 11/18/2021 435 11/19/2021 616 14216 14219 14222 14224 14228 14231 14233 14237 ITEM ITEM_ID DESCRIPTION AD72 Dog Feeding Station BC33 CA75 DT12 FM23 FS39 FS42 Feathers Bird Cage (12x24x18) Enclosed Cat Litter Station Dog Toy Gift Set Fly Mask with Ears Folding Saddle Stand Aquarium (55 Gallon) Wild Bird Food (25 lb) Locking Small Dog Door Large Pet Carrier Pump & Filter Kit Quilted Stable Blanket Small Pet Carrier INVOICE_LINE INVOICE_NUM ITEM_ID QUANTITY QUOTED_PRICE CA75 AD72 DT12 LD14 Underground Fence System 14216 14219 14219 14222 14224 14228 14228 14231 14233 14233 14233 14237 ON_HAND 12 10 15 27 41 12 5 24 14 23 5 32 KH81 FS42 PF19 UF39 KH81 QB92 WB49 LP73 18 7 34 CATEGORY DOG BRD CAT DOG HOR HOR FSH BRD DOG DOG FSH HOR CAT DOG HOR B B С B C C A C A B A 3 2 4 C B 1 KH81 LD14 LP73 PF19 QB92 SP91 UF39 WB49 Insulated Water Bucket FIGURE 2-1 Sample data for Kim Tay Pet Supplies (Continued) A C 4 1 LOCATION 1 2 1 4 4 3 $37.99 $79.99 $39.99 $47.99 $18.99 $124.99 $74.99 $189.99 $19.99 $109.95 $74.95 $54.95 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
Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 2-1. SALES REP REP_ID FIRST NAME LAST NAME Garcia Miller Smith Jackson 05 10 15 20 CUSTOMER CUST_FIRST_ LAST NAME Smith ID 125 182 227 294 314 435 492 543 Susan Richard Donna Daniel 616 721 NAME Joey Billy Sandra 375 Melanie Jackson Tom Samantha Smith James Elmer Angle Sally Rufton Leslie Pincher 795 Randy Rascal Gonzalez Jackson Cruz ADDRESS CITY STATE POSTAL CELL PHONE COMMISSION RATE 42 Mountain Ln Cody WY 82414 307-824-1245 $12,743.16 0.04 87 Pikes Dr Ralston WY 82440 307-406-4321 $20,872.11 0.06 312 Oak Rd WY 82440 $14,912.92 0,04 Powell Elk Butte WY 19 Lookout Dr 82433 $0,00 0,04 Smith ADDRESS 17 Fourth St 21 Simple Cir 53 Verde In 14 Rock La 1 Rascal Farm Rd 42 Blackwater Way 16 Rockway Rd Hendricks 27 Locklear Ln 199 18th Ave 22 Jackson Farm Rd CITY Blacksmith 75 Stream Rd STATE POSTAL EMAIL Cody WY 82414 Garland WY 82435 Powell WY 82440 Ralston WY 82440 Cody WY 82414 Elk Butte WY Wapiti WY Garland WY 82433 123 Sheepland Elk Butte WY Rd Cody WY 82450 82435 Powell WY 82440 Ralston WY 82440 82433 82414 .com jsmith17@example $80.68 billyruff@example $13.13 spinch2@example $156.38 ssmith5@example $58.60 trascal3@example $17.25 $252.25 .com .com .com .com mjackson5@ example.com jgonzo@example .com 307-982-8401 307-883-9481 ejackson@ example.com ahendricks7@ example.com scruz5@example .com .com BALANCE rblacksmith6@ example.com $45.20 CREDIT REP LIMIT ID $500.00 05 $315.00 $750.00 10 $500.00 15 $500.00 10 $250.00 15 $230.40 $1,000.00 15 $250.00 05 $8.33 Ismith12@example $166.65 $1,000.00 10 $500.00 10 $750.00 05 $500.00 15 $61.50 $500.0005
Transcribed Image Text:Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 2-1. SALES REP REP_ID FIRST NAME LAST NAME Garcia Miller Smith Jackson 05 10 15 20 CUSTOMER CUST_FIRST_ LAST NAME Smith ID 125 182 227 294 314 435 492 543 Susan Richard Donna Daniel 616 721 NAME Joey Billy Sandra 375 Melanie Jackson Tom Samantha Smith James Elmer Angle Sally Rufton Leslie Pincher 795 Randy Rascal Gonzalez Jackson Cruz ADDRESS CITY STATE POSTAL CELL PHONE COMMISSION RATE 42 Mountain Ln Cody WY 82414 307-824-1245 $12,743.16 0.04 87 Pikes Dr Ralston WY 82440 307-406-4321 $20,872.11 0.06 312 Oak Rd WY 82440 $14,912.92 0,04 Powell Elk Butte WY 19 Lookout Dr 82433 $0,00 0,04 Smith ADDRESS 17 Fourth St 21 Simple Cir 53 Verde In 14 Rock La 1 Rascal Farm Rd 42 Blackwater Way 16 Rockway Rd Hendricks 27 Locklear Ln 199 18th Ave 22 Jackson Farm Rd CITY Blacksmith 75 Stream Rd STATE POSTAL EMAIL Cody WY 82414 Garland WY 82435 Powell WY 82440 Ralston WY 82440 Cody WY 82414 Elk Butte WY Wapiti WY Garland WY 82433 123 Sheepland Elk Butte WY Rd Cody WY 82450 82435 Powell WY 82440 Ralston WY 82440 82433 82414 .com jsmith17@example $80.68 billyruff@example $13.13 spinch2@example $156.38 ssmith5@example $58.60 trascal3@example $17.25 $252.25 .com .com .com .com mjackson5@ example.com jgonzo@example .com 307-982-8401 307-883-9481 ejackson@ example.com ahendricks7@ example.com scruz5@example .com .com BALANCE rblacksmith6@ example.com $45.20 CREDIT REP LIMIT ID $500.00 05 $315.00 $750.00 10 $500.00 15 $500.00 10 $250.00 15 $230.40 $1,000.00 15 $250.00 05 $8.33 Ismith12@example $166.65 $1,000.00 10 $500.00 10 $750.00 05 $500.00 15 $61.50 $500.0005
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

What are the changes you need to make to meet the requirement? I need to know the changes without building a table.

Solution
Bartleby Expert
SEE SOLUTION
Similar questions
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS