Normalization: Transform the following relation into 3NF. Make appropriate assumptions about functional dependencies and domains. State your assumptions.
INVOICE(InvoiceNumber, CustomerName, CustomerNumber, CustomerAddress, ItemNumber, ItemPrice, ItemQuantity, SalespersonNumber, SalespersonName, SubTotal, Tax, TotalDue)
a) INVOICE(InvoiceNumber, CustomerName, CustomerNumber, CustomerAddress)
b) INVOICE_ITEMS(InvoiceNumber, ItemNumber, ItemPrice, ItemQuantity)
c) SALES_PERSON(SalespersonNumber, SalespersonName)
d) TRANSACTION(InvoiceNumber, ItemNumber, SalespersonNumber, SubTotal, Tax, TotalDue)
