Using the table below, complete the following tasks:

INVOICE

INV$\_$NUM

PROD$\_$NUM

SALE$\_$DATE

PROD$\_$LABEL

VEND$\_$

CODE

VEND$\_$NAME

QUANT$\_$

SOLD

PROD$\_$

PRICE

$211347$

AA$-$E$3422$QW

$15-$JAN$-2016$

Rotary sander

$211$

Neverfail, Inc.

$1$

$$49\mathrm{.}95$

$211347$

QD$-300932$X

$15-$JAN$-2016$

$0\mathrm{.}25-$in$.$ drill bit

$211$

Neverfail, Inc.

$8$

$$3\mathrm{.}45$

$211347$

RU$-995748$G

$15-$JAN$-2016$

Band saw

$309$

BeGood, Inc.

$1$

$$39\mathrm{.}99$

$211348$

AA$-$E$3422$QW

$15-$JAN$-2016$

Rotary sander

$211$

Neverfail, Inc.

$2$

$$49\mathrm{.}95$

$211349$

GH$-778345$P

$16-$JAN$-2016$

Power drill

$157$

ToughGo, Inc.

$1$

$$87\mathrm{.}75$

Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies in $1$NF$.$ You can assume that the table does not contain repeating groups and that an invoice number references more than one product.

Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams normalizing to $2$NF$.$ Identify the normal forms for each table structure you created.

Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams, normalizing to $3$NF$.$ Also, identify the normal forms for each table structure you created.

Draw the Crow$$s Foot ERD.