Throughout this course, you will utilize a case study from your Starks, Pratt & Last (2018) text to reinforce your understanding of the objectives for each module. The case is called the Colonial Adventure Tours. It presents a realistic business scenario that involves the creation, updating, querying and maintenance of a database that supports the operations of a firm. These are all very typical functions that are performed by both database administrators, and in some cases, end-users in an organization.

For this assignment, reinforce your understanding by addressing the following questions:

1. List the last name of each guide who does not live in Vermont [VT].

2. List the trip name of each trip that has the type Biking.

3. List the trip name of each trip that has the season Summer.

4. How many trips are in the states of New Hampshire [NH] or Connecticut (CT)?

5. List the trip name of each trip that has Glory Unser as a guide.

6. For each reservation that has a trip date of September 12, 2018, list the customer's last name, the trip name, and the start location.

7. How many reservations have a trip price that is greater than $25.00 but less than $100.00?

8. For each trip that has more than one guide that can lead the trip, list the trip name, and the first and last name of the guide.

9. For each customer that has more than one reservation, list the customer's first and last names, and the trip type.

10. Currently, trip cost is determined by the number of people taking the trip and the type of trip. If trip cost was based only on the type of trip, in which table would you place the trip cost field?