Compulsory Task $1$

Answer the following questions:

What is normalisation?

When is a table in INF?

When is a table in $2$ NF$?$

When is a table in $3NF?$

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.

$\backslash$table$[[\backslash$table$[[$Attribute$],[$Name$]],\backslash$table$[[$Sample$],[$Value$]],\backslash$table$[[$Sample$],[$Value$]],\backslash$table$[[$Sample$],[$Value$]],\backslash$table$[[$Sample$],[$Value$]],\backslash$table$[[$Sample$],[$Value$]]],[$INV$\_$NUM,$211347,211347,211347,211348,211349],[\backslash$table$[[$PROD$\_$NU$],[$M$]],\backslash$table$[[$AA$-$E$3522],[$QW$]],\backslash$table$[[$QD$-30093],[2x$