Colonial Adventure Tours is considering offering outdoor adventure classes. These classes would better prepare people to participate in hiking, biking, and paddling adventures. Only one class is taught on any given day. Participants can enroll in one class or several classes. Classes are taught by the guides that Colonial Adventure employs. Colonial Adventure Tours needs your help with the database design for this new venture. In each step, represent your answer in DBDL with a diagram. You may use any of the styles presented in this chapter for the diagram. Colonial Adventure Tours needs to produce the following reports:

a. For each participant, list his or her number, last name, first name, address, city, state, postal code, telephone number, and date of birth.

b. For each adventure class, list the class number, class description, maximum number of persons in the class, and class fee.

c. For each participant, list his or her number, last name, first name, and the class number, class description, and date of the class for all classes in which the participant is enrolled.