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

$05$ Susan Garcia $42$ Mountain Ln Cody WY $82414307-824-1245$ $$12,743\mathrm{.}160\mathrm{.}04$

$10$ Richard Miller $87$ Pikes Dr Ralston WY $82440307-406-4321$ $$20,872\mathrm{.}110\mathrm{.}06$

$15$ Donna Smith $312$ Oak Rd Powell WY $82440307-982-8401$ $$14,912\mathrm{.}920\mathrm{.}04$

$20$ Daniel Jackson $19$ Lookout Dr Elk Butte WY $82433307-883-9481$ $$0\mathrm{.}000\mathrm{.}04$

CUSTOMER

CUST$\_$ID FIRST$\_$NAME LAST$\_$NAME ADDRESS CITY STATE POSTAL EMAIL BALANCE CREDIT$\_$LIMIT REP$\_$ID

$125$ Joey Smith $17$ Fourth St Cody WY $82414$ jsmith$17$@example.com $$$$80\mathrm{.}68$$$500\mathrm{.}0005$

$182$ Billy Rufton $21$ Simple Cir Garland WY $82435$ billyruff@example.com $$$$43\mathrm{.}13$$$750\mathrm{.}0010$

$227$ Sandra Pincher $53$ Verde Ln Powell WY $82440$ spinch$2$@example.com $$156\mathrm{.}38$$$500\mathrm{.}0015$

$294$ Samantha Smith $14$ Rock Ln Ralston WY $82440$ ssmith$5$@example.com $$$$58\mathrm{.}60$$$500\mathrm{.}0010$

$314$ Tom Rascal $1$ Rascal Farm Rd Cody WY $82414$ trascal$3$@example.com $$$$17\mathrm{.}25$$$250\mathrm{.}0015$

$375$ Melanie Jackson $42$ Blackwater Way Elk Butte WY $82433$ mjackson$5$@example.com $$252\mathrm{.}25$$$250\mathrm{.}0005$

$435$ James Gonzalez $16$ Rockway Rd Wapiti WY $82450$ jgonzo@example.com $$230\mathrm{.}40$ $$1,000\mathrm{.}0015$

$492$ Elmer Jackson $22$ Jackson Farm Rd Garland WY $82435$ ejackson$4$@example.com $$$$45\mathrm{.}20$$$500\mathrm{.}0010$

$543$ Angie Hendricks $27$ Locklear Ln Powell WY $82440$ ahendricks$7$@example.com $$315\mathrm{.}00$$$750\mathrm{.}0005$

$616$ Sally Cruz $19918$th Ave Ralston WY $82440$ scruz$5$@example.com $$$$8\mathrm{.}33$$$500\mathrm{.}0015$

$721$ Leslie Smith $123$ Sheepland Rd Elk Butte WY $82433$ lsmith$12$@example.com $$166\mathrm{.}65$ $$1,000\mathrm{.}0010$

$795$ Randy Blacksmith $75$ Stream Rd Cody WY $82414$ rblacksmith$6$@example.com $$$$61\mathrm{.}50$$$500\mathrm{.}0005$

INVOICES

INVOICE$\_$NUM INVOICE$\_$DATE CUST$\_$ID

$1421611/15/2021125$

$1421911/15/2021227$

$1422211/16/2021294$

$1422411/16/2021182$

$1422811/18/2021435$

$1423111/18/2021125$

$1423311/18/2021435$

$1423711/19/2021616$

INVOICE$\_$LINE

INVOICE$\_$NUM ITEM$\_$ID QUANTITY QUOTED$\_$PRICE

$14216$ CA$753$$$37\mathrm{.}99$

$14219$ AD$722$$$79\mathrm{.}99$

$14219$ DT$124$$$39\mathrm{.}99$

$14222$ LD$141$$$47\mathrm{.}99$

$14224$ KH$814$$$18\mathrm{.}99$

$14228$ FS$421$ $$124\mathrm{.}99$

$14228$ PF$191$$$74\mathrm{.}99$

$14231$ UF$392$ $$189\mathrm{.}99$

$14233$ KH$811$$$19\mathrm{.}99$

$14233$ QB$924$ $$109\mathrm{.}95$

$14233$ WB$494$$$74\mathrm{.}95$

$14237$ LP$733$$$54\mathrm{.}95$

ITEM

ITEM$\_$ID DESCRIPTION ON$\_$HAND CATEGORY LOCATION PRICE

AD$72$ Dog Feeding Station $12$ DOG B $$79\mathrm{.}99$

BC$33$ Feathers Bird Cage $(12\backslash$times $24\backslash$times $18)10$ BRD B $$$$79\mathrm{.}99$

CA$75$ Enclosed Cat Litter Station $15$ CAT C $$$$39\mathrm{.}99$

DT$12$ Dog Toy Gift Set $27$ DOG B $$$$39\mathrm{.}99$

FM$23$ Fly Mask with Ears $41$ HOR C $$$$24\mathrm{.}95$

FS$39$ Folding Saddle Stand $12$ HOR C $$$$39\mathrm{.}99$

FS$42$ Aquarium $(55$ Gallon$)5$ FSH A $$124\mathrm{.}99$

KH$81$ Wild Bird Food $(25$ lb$)24$ BRD C $$$$19\mathrm{.}99$

LD$14$ Locking Small Dog Door $14$ DOG A $$$$49\mathrm{.}99$

LP$73$ Large Pet Carrier $23$ DOG B $$$$59\mathrm{.}99$

PF$19$ Pump & Filter Kit $5$ FSH A $$$$74\mathrm{.}99$

QB$92$ Quilted Stable Blanket $32$ HOR C $$119\mathrm{.}99$

SP$91$ Small Pet Carrier $18$ CAT B $$$$39\mathrm{.}99$

UF$39$ Underground Fence System $7$ DOG A $$199\mathrm{.}99$

WB$49$ Insulated Water Bucket $34$ HOR C $$$$79\mathrm{.}991.$ 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 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.