Colonial Adventure Tours Case 1. These are in a database to produce the following reports. Do not use any surrogate keys in your design. a. For each guide, list the guide number, died last name, guides 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 mainly to many trips and the 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 conditional fees per person,
You've reached the end of your free preview.
Want to read the whole page?
- Fall '19
- English-language films, E-participation, Family name