Using the INVOICE table given below, draw its dependency diagram and

identify all dependencies $($including transitive and partial dependencies$).$

You can assume that the table does not contain any repeating groups and

that an invoice number references more than one product. Hint: This table

uses a composite primary key.

Attribute

Name

Sample

Value

Sample

Value

Sample

Value

Sample

Value

Sample

Value

INV$\_$NUM $211347211347211347211348211349$

PROD$\_$NU

M

AA$-$E$3522$

QW

QD$-30093$

$2$X

RU$-99574$

$8$G

AA$-$E$3522$

QW

GH$-77834$

$5$P

SALE$\_$DAT

E

$15-$Jan$-201$

$8$

$15-$Jan$-201$

$8$

$15-$Jan$-201$

$8$

$15-$Jan$-201$

$8$

$16-$Jan$-201$

$8$

PROD$\_$LA

BEL

Rotary

sander

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

Drill bit

Band saw Rotary

sander

Power drill

VEND$\_$CO

DE

$211211309211157$

VEND$\_$NA

ME

NeverFail,

Inc.

NeverFail,

Inc.

BeGood,

Inc.

NeverFail,

Inc.

ToughGo,

Inc.

QUANT$\_$S

OLD

$18121$

PROD$\_$PRI

CE

$$34\mathrm{.}46$ $$2\mathrm{.}73$ $$31\mathrm{.}59$ $$34\mathrm{.}46$ $$69\mathrm{.}32$

$$ Using the answer to the above question, remove all partial dependencies

and draw the new dependency diagrams. Identify the normal forms for

each table structure you created.

$$ Using the answer to the above question, remove all transitive dependencies

and draw the new dependency diagrams. Identify the normal forms for

each table structure you created