1. design a database to produce the following reports. do not use any surrogate keys inyour 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 tripstarts, the state in which the trip originates, the trip distance, the maximum group size, thetype of trip (hiking, biking, or paddling), the season in which the trip occurs, and theguide number, first name and last name for each guide. a guide may lead many trips anda 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 included1n the reservation, the price of the trip per person, the total or any additional fees perperson, and the customer number, first name, and last name of the customer who madethe reservation.