Colonial Adventure Tours Answer each of the following questions using the Colonial Adventure Tours data shown in Figures 1-4 through 1-8 in Chapter 1. No computer work is required 1. Using the types of entities found in the Colonial Adventure Tours database (trips, guides customers, and reservations), create an example of a table that is in first normal form but not in second normal form, and an example of a table that is in second normal form but not in third normal form. In each case, justify your answers and show how to convert to the higher forms. 2. Identily the functional dependencies in the tollowing unnormalized table. Convert the table to third normal form. TRIP (TRIP ID, TRIP NAME, STATR ABBREVIATION, STATE NAMB, (GUIDE NUN GUIDE LAST GUIDE FIRST