Using your knowledge of TAL Distributors, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form. ITEM (TEM NUM, DESCRIPTION, ONHAND, CATEGORY, STOREHOUSE, PRICE, 4. - (ORDER NUM, ORDER DATE, CUSTOMER NUM, CUSTOMER NAME,NUM ORDERED, QUOTED PRICE)) Indicate the changes you need to make to the TAL Distributors database to support the fol- lowing additional requirement. Each storehouse has a manager who is identified by a man- ager number, a manager last name, and a manager first name. 5. 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. 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 1. x 2. Identify the functional dependencies in the tollowing unnormalized table. Convert the table to third normal form. TRIP fTRIP ID. TRIP NAMB, STATR ABBREVIATIONSTATE NAMR GUIDE NUM GUIDE LAST, GUIDEFIRST)) - 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, tist his or her number, last name, first name, address, city 3. state, postal code, telephone number, and date of birth b. 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 c. d