Using Colonial Adventure Tours database (pictured below) to complete the following exercises.

c. Add a row to the GUIDE table. d. Change the last name of the guide whose number is stored in L_GUIDE NUM to the value currently found in I _LAST NAME. e. Delete the guide whose number is stored in I GUIDE NUM. 5. Write PLUSQL or T-SQL procedures to retrieve and output the reservation ID, trip ID, number of persons, and trip price for every reservation whose customer number is stored in I_CUSTOMER NUM. 6. Write Access functions to accomplish the following tasks: a. Delete the guide whose number is stored in GUIDE NUM. b, Change the last name of the guide whose number is stored in l-GUIDE-NUM to the value currently found in l-GUIDE-LAST. c. Retrieve and output the reservation ID, trip ID, trip date, number of persons, and trip price for every reservation whose customer number is stored in I CUSTOMER NUM 7. Write a stored procedure in PL/SOL or T-SOL that will change the maximum group size of a trip with a given trip ID. How would you use this stored procedure to change the maxi- mum group size of trip 21 to 15