MGMT 392 week 5 Database Management assignment. Must have Colonial Adventure Tours database.

You will continue working with the Colonial Adventure Tours database,

using it to demonstrate the significant rules within the normalization

process. Using any of the entities found in the database (i.e., trips,

guides, clients, and reservations), complete the following:

1. Create 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.
2. Create 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.
3. Create 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.
4. 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)

Copy and paste your work into a document and submit.

Your instructor will assess your performance and assign your grade.