Can someone help me with these questions? I'm very confused.

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. Identify the functional dependencies in the following unnormalized table. Convert the table to third normal form. TRIP (TRIP ID, TRIP NAME, STATE ABBREVIATION, STATE NAME, (GUIDE NUM GUIDE LAST, GUIDE FIRST)) 3. Colonial Adventure Tours is considering offering outdoor adventure classes to prepare people to participate in hiking, biking, and paddling adventures. Only one class is taught on any given day. Participants can enroll in one or more classes. Classes are taught by the guides that Colonial Adventure employs. Participants do not know who the instructor for a particular class will be until the day of the class. Colonial Adventure Tours needs your help with the database design for this new venture. In each step, represent your answer using the shorthand representation and a diagram. You may use any of the styles presented in this chapter for the diagram. a. For each participant, list his or her number, last name, first name, address, city state, postal code, telephone number, and date of birth. For each adventure class, list the class number, class description, maximum number of people in the class, and class fee For each participant, list his or her number, last name, first name, and the class number, class description, and date of the class for each class in which the partici- pant is enrolled. For each class, list the class date, class number, and class description; and the number, last name, and first name of each participant in the class. b. c. d