Extra Credit

Understanding Databases

Use the following partial database tables to answer the required questions:

Sales Table

Sales Event # Dat

e

Terms Salesperson ID Customer ID

$111/5210,$ net $3022543$

$211/5210,$ net $304635$

$311/5$ COD $61845$

Sale$-$Inventory Table

Sale Event # Inventory Item # Inventory Quantity Price each

$1876101\mathrm{.}25$

$167480\mathrm{.}875$

$1451300\mathrm{.}995$

$2887541\mathrm{.}475$

$25131880\mathrm{.}525$

$37363624\mathrm{.}995$

$3001587\mathrm{.}875$

$3302168\mathrm{.}00$

$32241148\mathrm{.}75$

Salesperson Table

Salesperson ID Last Name First Name

$2$ Cleaves Mateen

$4$ Warrick Peter

$6$ Peterson Morris

$8$ Janakowski Sebastian

Cashier Table

Cashier ID Last Name First Name

$1$ Weinke Chris

$2$ Outzen Marcu