Section $3-$Normalization $(6$ points$)$

Determine the current normal form of a group of attributes and normalize it to $3NF$ relation.

Invoice $($InvoiceNo$,$ ClerkNo, ClorkName, Position, CustomerID, CustomerName, Address,

Date, $($ItemNo$,$ ItermName, Price, Quantity$))$

The functional dependencies $($FD$)$ are:

CustomerID $\{$CustomerName$,$ Address$\}$

InvoiceNo, ItemNo $$ Quantity $($full FD$)$

ClerkNo $$ ClerkName, Position

ItemNo $$ ItermName, Price

Normalize Invoice schema by providing the corresponding relations in $1NF,2NF,$ and $3NF$ :

Note: List all relations for each normal form and underline the primary key $($PK$).$

$1NF$ :

$2NF$ :

$3$NF: