$*$ First step for database is to modify the Vendor table and add in all vendor's addresses. The information is included in the list below. Be sure to set up fields with appropriate data types and the appropriate properties. $(4$ points$)$

Illumination, Inc, $526$ Industrial Parkway, Palo Alto CA $94544$

Team Supplies, $2819$ Stadium Drive, Dallas Texas $76012$

Webster Distribution, $1200$ Pinnacle Rd$,$ Memphis TN $38104$

Grant Sales, $1406$ Bishop Rd$,$ Suite $112,$ Lexington KY $40512$

Copper River Manufacturing, $1$ Warehouse Street, Seattle Washington $98105$

$*$ After modifying the Vendor table, establish relationships between the tables using the Relationships tool

$*$ Last steps are to create queries for each of the following questions:

$1.$ What is the total current inventory value? Include the product name, category, vendor name, cost, quantity on hand along with the current inventory value. Name this query Current Inventory Cost

$2.$ Grant Sales has contacted us and indicated some supply chain problems with a few of their products. They are checking with all customers to determine which inventory items are in low amount $(5$ or less$).$ Include the product name, category, and quantity on hand attributes in this query along with other attributes you deem pertinent to this inquiry. Name this query Grant Sales Inquiry

$3.$ The company will be holding a sale on lighting products in two weeks and needs to know what inventory is on hand. The company sells a variety of lamps and chandeliers. Include product name, vendor, and quantity on hand. Name this query Lighting Sale Inventory

$4.$ VP$-$Sales has asked for a quick report on total dollar amount of inventory by category. Prepare this query to provide an answer for the vice president. Name this query Inventory Value by Category

$5.$ The company has a category of product offerings by selling custom$-$made uniforms to local businesses. Determine the price for all clothing category products by applying the margin markup via a calculated field. Include the product name, category, cost, margin along with the price calculations. Name this query Uniform Pricing. Vendor

Product

VendorProductInventory

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|\}$

$\backslash$hline Vendorld & ProductID & QuantityOnHand $\backslash \backslash$

$\backslash$hline $1$ & $2$ & $47\backslash \backslash$

$\backslash$hline $1$ & $3$ & $102\backslash \backslash$

$\backslash$hline $1$ & $6$ & $32\backslash \backslash$

$\backslash$hline $1$ & $11$ & $52\backslash \backslash$

$\backslash$hline $1$ & $16$ & $25\backslash \backslash$

$\backslash$hline $1$ & $21$ & $0\backslash \backslash$

$\backslash$hline $1$ & $22$ & $13\backslash \backslash$

$\backslash$hline $1$ & $27$ & $19\backslash \backslash$

$\backslash$hline $1$ & $31$ & $9\backslash \backslash$

$\backslash$hline $1$ & $35$ & $19\backslash \backslash$

$\backslash$hline $1$ & $40$ & $19\backslash \backslash$

$\backslash$hline $1$ & $43$ & $19\backslash \backslash$

$\backslash$hline $1$ & $45$ & $7\backslash \backslash$

$\backslash$hline $1$ & $47$ & $11\backslash \backslash$

$\backslash$hline $1$ & $50$ & $47\backslash \backslash$

$\backslash$hline $1$ & $52$ & $88\backslash \backslash$

$\backslash$hline $1$ & $54$ & $36\backslash \backslash$

$\backslash$hline $1$ & $56$ & $21\backslash \backslash$

$\backslash$hline $2$ & $2$ & $21\backslash \backslash$

$\backslash$hline $2$ & $3$ & $7\backslash \backslash$

$\backslash$hline $2$ & $4$ & $10\backslash \backslash$

$\backslash$hline $2$ & $6$ & $36\backslash \backslash$

$\backslash$hline $2$ & $7$ & $24\backslash \backslash$

$\backslash$hline $2$ & $8$ & $14\backslash \backslash$

$\backslash$hline $2$ & $9$ & $5\backslash \backslash$

$\backslash$hline $2$ & $11$ & $95\backslash \backslash$

$\backslash$hline $2$ & $12$ & $5\backslash \backslash$

$\backslash$hline $2$ & $13$ & $19\backslash \backslash$

$\backslash$hline $2$ & $14$ & $21\backslash \backslash$

$\backslash$hline $2$ & $27$ & $13\backslash \backslash$

$\backslash$hline $2$ & $35$ & $30\backslash \backslash$

$\backslash$hline $2$ & $36$ & $35\backslash \backslash$

$\backslash$hline $2$ & $37$ & $13\backslash \backslash$

$\backslash$hline $2$ & $39$ & $23\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Record:

$1$ of $177$

Search Vendor

Product

Record:

$1$ of $57$

Search Vendor

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline VendorID & VendorName & Street Addres $-$ & City & & State & $\backslash (\backslash$cdot $\backslash )$ & Zip Code & $\backslash (\backslash$cdot $\backslash )$ & FurnitureMargin & AccessoryMargin & ClothingMargin & LinenMargin & & ShippingMar $\backslash \backslash$

$\backslash$hline & $1$Illumination, Inc & $526$ Industrial P & Alto & & & & $94544$ & & $0\mathrm{.}2$ & $0\mathrm{.}2$ & $0\mathrm{.}2$ & & $0\mathrm{.}2$ & $\backslash \backslash$

$\backslash$hline & $2$ Team Supplies & $2819$ Stadium D & & & & & $76012$ & & $0\mathrm{.}25$ & $0\mathrm{.}25$ & $0\mathrm{.}25$ & & $0\mathrm{.}25$ & $\backslash \backslash$

$\backslash$hline & $3$ Webster Distributio & or $1200$ Oinnacle F & mphis & & & & $38104$ & & $0\mathrm{.}3$ & $0\mathrm{.}3$ & $0\mathrm{.}3$ & & $0\mathrm{.}3$ & $\backslash \backslash$

$\backslash$hline & $4$ Grant Sales & $1406$ Bishop Rd & ngton & & & & $40512$ & & $0\mathrm{.}4$ & $0\mathrm{.}4$ & $0\mathrm{.}4$ & & $0\mathrm{.}4$ & $\backslash \backslash$

$\backslash$hline & $5$ Copper River Manu & fi $1$ Warehouse St & & & & & $98105$ & & $0\mathrm{.}5$ & $0\mathrm{.}5$ & $0\mathrm{.}5$ & & $0\mathrm{.}5$ & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$