Functional dependencies exist between the attributes
Computer Science
Consider the following entity and its attributes:
INVOICE (InvoiceID, CustomerName, CustomerID, CustomerAddress, ItemID, ItemPrice, ItemQuantity, SalesPersonID, SalesPersonName, Subtotal, Tax, TotalDue)
Identify the Primary Key(s) and the Foreign Key(s).
What issue does this entity have that can be solved by normalization?
What functional dependencies exist between the attributes?
How would you apply normalization to break this into more than one entity, each with a single theme?
