mgmt 392 database management must have access to colonial adventure tours database from concepts of database managemnt 9th edition textbook 1

Hello,

Here are the instructions. Also, SQL Server queries will be required.

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:

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.
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.
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.
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.