Colonial Adventure Tours Case 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.
You've reached the end of your free preview.
Want to read all 7 pages?
- Spring '16
- English-language films, Grammatical person