Use SQL to make the following changes to the Colonial Adventure Tours database. Figures 1-4 through 1-8 pictured below, after each change, execute an appropriate query to show that the change was made correctly.

TRIP INDLU 7. Delete the index named 8. Write the commands to obtain the following information from the system catalo execute these commands unless your instructor asks you to do so. a. List every column in the GUIDE table and its associated data type. b. List every table that contains a column named TRIP-ID. c. List the table name, column name, and data type for the columns named TRI TRIP ID, n column name . (That TRIP_NAME, and TYPE. Order the results by table name withi is, column name is the major sort key and table name is the minor sort key.) 9. Add the CUSTOMER NUM column as a foreign key in the RESERVATION table. 10. Ensure that the only legal values for the TYPE column in the TRIP table are Biking, Hiking, or Paddling. 11. The maximum group size for a trip must be greater than one. Use the Internet to research the CHECK clause, determine how to add this constraint to the TRIP table, and then write the SQL command to make this change to the TRIP table. Be sure to cite your references