1. In our design of the database, we need store each participant's customerlD, name, and contact info along with the reservation. Also, we put the tripID, trip date, price. Assume that for the same trip, its price and fees are fixed (the same in all reservations). To fulfill this design the following reservation table is designed (ReservationID is the primary key) Reservation (ReservationID, TripID, Trip Date, Price, Fees, (CustomerlD, Last Name, FirstName phone)) Example Reservation table: ReservationID TripID TripDate Price Fees CustomerID LastName FirstName Phone 1600001 Northfold Liam Ocean Northfold Liam Kasuma Sujata Chau Brown 21 3/12/17 $56 $20 101 102 558-8432 435-9834 558-8432 787-3224 Clement 887-4463 Brianne 442-5543 Arnold 6/18/17$80$15101 21 4/3/17 $56 $20 103 119 126 1600002 32 1600003 Please normalize the Reservation table into 3rd normal form