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

INV_NU M	PROD_N UM	SALE_DA TE	PROD_LA BEL	VEND_C ODE	VEND_N AME	QUANT_ SOLD	PROD_P RICE
211347	AX-P126V BB	15-Jun-20 18	Lawnmo wer	111	Mowers and Bulbs	1	R4099.90
211347	GF-5106D 2F	15-Jun-20 18	Lightbulb	111	Mowers and Bulbs	8	R24,99
211347	RB-16369 8G	15-Jun-20 18	Blue paint	063	All Things Paint	1	R80,90
211348	AX-P126V BB	15-Jun-20 18	Lawnmo wer	111	Mowers and Bulbs	2	R4099.90
211349	TF-74650 23Q	17-Jun-20 18	2m ladder	207	Tall Things	1	R699,99

• Draw new dependency diagrams to show the data in 2NF.

• Draw new dependency diagrams to show the data in 3NF.

• Use this table to illustrate one of each kind of anomaly described in the task. In a text file called anomalies.txt, how you would change the table and which anomaly that change would create.

Answer rating: 100% (QA)

1Dependency diagram to show in 2NF Inv Num Prod Num Prod Num I... View the full answer