What are the SQL codes?

4. Create the following indexes. If it is necessary to name the index in your DBMS, use the indicated name.

a. Create an index named TripIndex1 on the TripName field in the Trip table.

b. Create an index named TripIndex2 on the Type field in the Trip table.

c. Create an index named TripIndex3 on the Type and Season fields in the Trip table and list the seasons in descending order.

7. Ensure that the following are foreign keys (that is, specify referential integrity within the Colonial Adventure Tours database). NOTE: Just verify a. and b. Nothing needs to be implemented.

a. CustomerNum is a foreign key in the Reservation table.

b. TripID is a foreign key in the Reservation table.

8. Add to the Customer table a new character field named Waiver that is one character in length.

9. Change the value in the Waiver field in the Customer table to Y for the customer with the last name of Ocean.

10. Change the length of the StartLocation field in the Trip table to 60.

12. Complete the following steps.

a. Add a PreviousTrip field to the Customer table. Create and run a totals query on the Reservation table to count the number of reservations by customer. Manually update the Customer table with these values. Assign the value 0 to customers 110 and 123.