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

Fundamentals of Information Systems
9th Edition
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter4: Networks And Cloud Computing
Section: Chapter Questions
Problem 7SAT
icon
Related questions
Question
SALES REP
RATE
POSTAL
CELL PHONE COMMISSION
CITY
STATE
ADDRESS
REP ID FIRST NAME LAST NAME
0,04
WY
82414
307-824-1245
$12,743.16
Susan
Garcia
42 Mountain Ln Cody
05
82440
307-406-4321
$20,872.11
0.06
Miller
87 PIkes Dr
Ralston
WY
10
Richard
$14,912.92
0.04
Powell
WY
82440
307-982-8401
15
Donna
Smith
312 Oak Rd
Elk Butte
WY
82433
307-883-9481
S0.00
0.04
20
Daniel
Jackson
19 Lookout Dr
CUSTOMER
CITY
STATE POSTAL EMAIL
BALANCE
CREDIT REP
ADDRESS
CUST FIRST_
ID
LAST
NAME
LIMIT
ID
NAME
125
Joey
17 Fourth St
Cody
WY
82414
Jkmlth17@exmple
S80.68
$500.00 05
Smith
Com
182
Billy
Rufton
21 Simple Cir
Garland WY
82435
billyrufi@example
$13.13
$750.00 10
:Com.
227
Bandra
Pincher
53 Verde Ln
Powell
WY
82440
spinch2@example
$156.38
$500.00 15
com
294
Samantha Smith
14 Rock Ln
Ralston
WY
82440
ssmith5@exnmple
$58.60
$500.00 10
Com
Rasenl
1 Raseal
Рarm Rd
Cody
314
Tom
WY
82414
traseal3@example
$17.25
$250.00 15
.com
375
Melanle
Jnokson
42 Blaokwater
Way
16 Rockwny
Rd
Elk Butte WY
mjackson5@
example.com
Jgonzo@example
82433
$252.25
$250.00 05
435
James
Gonzalez
Waplti
WY
82450
$230.40 $1,000.00
15
com
492
Elmer
Jackson
22 Jnckson
Farm Rd
Garland
WY
82435
ejackson4@
example.com
nhendricks7@
example.com
soruz5@example
$45.20
$500.00 10
543
Angle
Hendricks
27 Locklear
Ln
Powell
WY
82440
$315.00
$750.00 05
616
Sally
Cruz
199 18th Ave
Ralston
WY
82440
$8.33
S500,00 15
721
Leslie
Smith
con
123 Sheepland Elk Butte WVY
Rd
82433
Ismith12@example
$166.65 $1,000.00 10
795
Randy
Blacksmith 75 Stream Rd
Cody
com
WY
82414
rblacksmith6O
Oxnmple.com
$61.50
S500.00 05
Transcribed Image Text:SALES REP RATE POSTAL CELL PHONE COMMISSION CITY STATE ADDRESS REP ID FIRST NAME LAST NAME 0,04 WY 82414 307-824-1245 $12,743.16 Susan Garcia 42 Mountain Ln Cody 05 82440 307-406-4321 $20,872.11 0.06 Miller 87 PIkes Dr Ralston WY 10 Richard $14,912.92 0.04 Powell WY 82440 307-982-8401 15 Donna Smith 312 Oak Rd Elk Butte WY 82433 307-883-9481 S0.00 0.04 20 Daniel Jackson 19 Lookout Dr CUSTOMER CITY STATE POSTAL EMAIL BALANCE CREDIT REP ADDRESS CUST FIRST_ ID LAST NAME LIMIT ID NAME 125 Joey 17 Fourth St Cody WY 82414 Jkmlth17@exmple S80.68 $500.00 05 Smith Com 182 Billy Rufton 21 Simple Cir Garland WY 82435 billyrufi@example $13.13 $750.00 10 :Com. 227 Bandra Pincher 53 Verde Ln Powell WY 82440 spinch2@example $156.38 $500.00 15 com 294 Samantha Smith 14 Rock Ln Ralston WY 82440 ssmith5@exnmple $58.60 $500.00 10 Com Rasenl 1 Raseal Рarm Rd Cody 314 Tom WY 82414 traseal3@example $17.25 $250.00 15 .com 375 Melanle Jnokson 42 Blaokwater Way 16 Rockwny Rd Elk Butte WY mjackson5@ example.com Jgonzo@example 82433 $252.25 $250.00 05 435 James Gonzalez Waplti WY 82450 $230.40 $1,000.00 15 com 492 Elmer Jackson 22 Jnckson Farm Rd Garland WY 82435 ejackson4@ example.com nhendricks7@ example.com soruz5@example $45.20 $500.00 10 543 Angle Hendricks 27 Locklear Ln Powell WY 82440 $315.00 $750.00 05 616 Sally Cruz 199 18th Ave Ralston WY 82440 $8.33 S500,00 15 721 Leslie Smith con 123 Sheepland Elk Butte WVY Rd 82433 Ismith12@example $166.65 $1,000.00 10 795 Randy Blacksmith 75 Stream Rd Cody com WY 82414 rblacksmith6O Oxnmple.com $61.50 S500.00 05
INVOICE LINE
INVOICES
INVOICE NUM ITEM ID QUANTITY
QUOTED_PRICE
INVOICE NUM INVOICE DATE CUST ID
11/15/2021
11/15/2021
$37.99
S79.99
S39.99
$47.99
$18.99
S124.99
S74.99
S189.99
S19.99
S109.95
S74.95
$54.95
CA75
AD72
DT12
LD14
14216
14219
14219
14222
14224
14228
14228
14231
14216
125
227
294
182
435
125
435
14219
4.
11/16/2021
11/16/2021
11/18/2021
11/18/2021
11/18/2021
11/19/2021
14222
14224
14228
14231
14233
14237
KII81
FS42
PF19
UF39
2
1.
616
KHSI
OB92
WB49
LP73
14233
14233
14233
14237
4.
ITEM
ITEM ID DESCRIPTION
ON HAND
CATEGORY
LOCATION
PRICE
AD72
Dog Feeding Station
Feathers Bird Cage (12x24x18)
Enclosed Cat Litter Station
Dog Toy Cift 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
12
DOG
BC33
CA75
DT12
FM23
FS39
FS42
S79,99
S79.99
S39,99
$39.99
10
BRD
CAT
DOG
15
27
41
12
HOR
HOR
FSH
BRD
C:
$39.99
$124.99
S19.99
$49.99
$59.99
$74.99
$119.99
S39.99
$199.99
$79.99
KH81
24
14
23
LD14
DOG
LP73
PF19
FSH
OB92
32
HOR
CAT
DOG
HOR
SP91
Small Pet Carrier
UF39
18
Underground Fence System
Insulated Water Bucket
WB49
34
FIGURE 2-1 Sample data for Kim Tou Dat O
Transcribed Image Text:INVOICE LINE INVOICES INVOICE NUM ITEM ID QUANTITY QUOTED_PRICE INVOICE NUM INVOICE DATE CUST ID 11/15/2021 11/15/2021 $37.99 S79.99 S39.99 $47.99 $18.99 S124.99 S74.99 S189.99 S19.99 S109.95 S74.95 $54.95 CA75 AD72 DT12 LD14 14216 14219 14219 14222 14224 14228 14228 14231 14216 125 227 294 182 435 125 435 14219 4. 11/16/2021 11/16/2021 11/18/2021 11/18/2021 11/18/2021 11/19/2021 14222 14224 14228 14231 14233 14237 KII81 FS42 PF19 UF39 2 1. 616 KHSI OB92 WB49 LP73 14233 14233 14233 14237 4. ITEM ITEM ID DESCRIPTION ON HAND CATEGORY LOCATION PRICE AD72 Dog Feeding Station Feathers Bird Cage (12x24x18) Enclosed Cat Litter Station Dog Toy Cift 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 12 DOG BC33 CA75 DT12 FM23 FS39 FS42 S79,99 S79.99 S39,99 $39.99 10 BRD CAT DOG 15 27 41 12 HOR HOR FSH BRD C: $39.99 $124.99 S19.99 $49.99 $59.99 $74.99 $119.99 S39.99 $199.99 $79.99 KH81 24 14 23 LD14 DOG LP73 PF19 FSH OB92 32 HOR CAT DOG HOR SP91 Small Pet Carrier UF39 18 Underground Fence System Insulated Water Bucket WB49 34 FIGURE 2-1 Sample data for Kim Tou Dat O
Expert Solution
Step 1

ITEM_ID which is unique and primary key in ITEM table can act as a identifier for ITEM.

Using (CUST_ID) we can uniquely identify each customer and INVOICE_NUM+CUST_ID to identify sales rep associated with that purchase.

Hence, we can identity the customer and sales rep details in the database, using ER diagram. We can add other attributes each table accordingly.

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning