An Order table has key OrderID and fields CustomerID and CustomerName; CustomerID determines CustomerName. Why is it not in 3NF?
- CustomerName depends on CustomerID, not on OrderID.
- That is a transitive dependency.
- Move CustomerName to a Customer table.
Answer CustomerName depends on CustomerID: a transitive dependency