Complete the following tasks. In each exercise, represent your answer in both DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram.
1. Design a database to produce the following reports. Do not use any surrogate keys in your design.
a. For each guide, list the guide number, guide last name, guide first name, address, city, state, postal code, telephone number, and date hired.
b. For each trip, list the trip ID number, the trip name, the location from which the trip starts, the state in which the trip originates, the trip distance, the maximum group size, the type of trip (hiking, biking, or paddling), the season in which the trip occurs, and the guide number, first name, and last name of each guide. A guide may lead many trips and a trip may be led by many different guides.
c. For each customer, list the customer number, customer last name, customer first name, address, city, state, postal code, and telephone number.
d. For each reservation, list the trip ID number, the trip date, the number of persons included in the reservation, the price of the trip per person, the total of any additional fees per person, and the customer number, first name, and last name of the customer who made the reservation.
2. Expand the database design you created in Exercise 1 so that it will support the following situation: A reservation agent handles each reservation. Along with all the details concerning a reservation listed in Exercise 1, list the number, last name, and first name of the agent that handled the reservation.

3. 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. 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 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.
d. For each scheduled class, list the class date, class number, class description, the number, last name, and first name of each participant in the class as well as the actual number of participants enrolled in the class.