Create a table that is in first normal form but not in second normal form using the types of entities found in the Colonial Adventure Tours database (trips, guides, clients, and reservations) and a...

Create a table that is in first normal form but not in second normal form using the types of entities found in the Colonial Adventure Tours database (trips, guides, clients, and reservations) and a table that is in second normal form but not in third normal form using the types of entities found in the Colonial Adventure Tours database (trips, guides, clients, and reservations). Justify your replies in each circumstance and show how to transition to higher forms.