Assessment Description

Using the INVOICE table structure shown in Table $1,$ do the following:

Table $1$:

$\backslash$table$[[\backslash$table$[[$Attribute$],[$Name$]],$Sample Value,Sample Value,Sample Value,Sample Value,Sample Value$],[$INV$\_$NUM,$1001,1002,1003,1004,1005],[$PROD$\_$NUM,$\backslash$table$[[123-21$UUY, SRE$-],[657$UG$]],$QER$-34256,\backslash$table$[[$SRE$-657$UG$,],[$ZZX$/3245$Q$]],\backslash$table$[[$SRE$-657$UG$,],[\text{'}001278-$AB$\text{'}]],$ZZX$/3245$Q$],[$SALE$\_$DATE,$\text{'}2022-3-8\text{'},\text{'}2022-3-8\text{'},\text{'}2022-3-8\text{'},\text{'}2022-3-9\text{'},\text{'}2022-1-16\text{'}],[$PROD$\_$DESC,$\backslash$table$[[$Houselite chain$],[$saw$,$ Rat$-$tail file$]],$Sledge hammer,$\backslash$table$[[$Rat$-$tail file,$],[$Steel tape$]],\backslash$table$[[$Rat$-$tail file, claw$],[$hammer$]],$Steel tape$]]$

Page $2$ of $5$

ICT$201$ Database Systems

Assessment $2$

$\backslash$table$[[$VEND$\_$CODE,$235,232,231,232,235,232,231,235],[$VEND$\_$NAME,$\backslash$table$[[$Shelly K$.],[$Smithson$,],[$Annelise Crystall$]],$James Johnson,$\backslash$table$[[$Annelise$],[$Crystall$,]],\backslash$table$[[$Shelly K$.],[$Smithson$,$ James$],[$Johnson$]],$Arthur Jones$],[$QUANT$\_$SOLD,$1,3,1,1,2,1,2,1],[$PROD$\_$PRICE,$$189\mathrm{.}99,$ $$2\mathrm{.}99,18\mathrm{.}63,$$$6\mathrm{.}79,$$$2\mathrm{.}99,$$$12\mathrm{.}95,2\mathrm{.}99,$$$2\mathrm{.}99$