Complete the following tasks. In each exercise, represent youranswer only in DBDL. Do not use diagrams a this point. Submiteither a text file or a Word document with your work. Make sure youfollow chapter 6's DBDL notation
(****** Just to clarify: this is the first question on Page220. It says to 'produce the following reports', but what you areasked to do is use DBDL notation to create 5 tables: Guide,Trip, Customer, Reservation and TripGuides
Make sure to list the FK where they belong ******)
- Design a database to produce the following reports. Donot use any surrogate keys in your design.
- For each guide, list the guide number, guidelast name, guide first name, address, city, state, postal code,telephone number, and date hired.
- For each trip, list the trip ID number, thetrip name, the location from which the trip starts, the state inwhich the trip originates, the trip distance, the maximum groupsize, the type of trip (hiking, biking, or paddling), the season inwhich the trip occurs, and the guide number, first name, and lastname of each guide. A guide may lead many trips and a trip may beled by many differen't guides.
- For each customer, list the customer number,customer last name, customer first name, address, city, state,postal code, and telephone number.
- 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 feesper person, and the customer number, first name, and last name ofthe customer who made the reservation.
