Give an example of a table that is not in first normal form. Explain how it violates first normal form and what could be done to correct it.
Give an example of a table that is in first normal form but not in second normal form. Explain how it violates second normal form and what could be done to correct it.
Give an example of a table that is in second normal form but not in third normal form. Explain how it violates third normal form and what could be done to correct it.
The following table was created. Either justify that it is in third normal form, or discuss which normal form rule it violates and why. If not in third normal form, identify the table(s) (including attributes) required to be in third normal form.
TRIP (Tripid, TripName, CustomerID, CustomerName, StateCode, StateName)