Answer each of the following questions using the Colonial Adventure Tours data shown in Figures 1-15 through

Question:

Answer each of the following questions using the Colonial Adventure Tours data shown in Figures 1-15 through 1-19. No computer work is required.
1. List the last name of each guide that does not live in New Hampshire (NH).

2. List the trip name of each trip that has the type Paddling.
3. List the trip name of each trip that has the season Late Spring.
4. List the trip name of each trip that has the type Biking and that has a distance longer than 20 miles.
5. List the trip name of each trip that is in the state of Vermont (VT) or that has a maximum group size greater than 15.
6. List the trip name of each trip that has the season Early Fall or Late Fall.
7. How many trips are in the states of Vermont (VT) or Connecticut (CT)?
8. List the trip name of each trip that has Miles Abrams as a guide.
9. List the trip name of each trip that has the type Biking and that has Rita Boyers as a guide.
10. For each reservation that has a trip date of July 23, 2016, list the customer€™s last name, the trip name, and the start location.
11. How many reservations have a trip price that is greater than $50.00 but less than $100.00?
12. For each trip that has more than one guide that can lead the trip, list the trip name, the trip type, and the first and last names of each guide.
13. For each customer that has more than one reservation, list the customer€™s first and last names, the trip name, and the trip type.
14. For each reservation with a trip price of greater than $100.00, list the customer€™s last name, the trip name, and the trip type.
15. List the last name of each customer who has a reservation for a trip in Maine (ME).
16. The trip price in the Reservation table is a per-person price. The total price for a trip includes the total of the trip price and the other fees multiplied by the number of people taking the trip. Should total price be a field in the Reservation table? Why or why not?
17. Currently, trip cost is determined by the number of people taking the trip and the type of trip. If trip cost were based only on the type of trip, in which table would you place the trip cost field?

Figure 1-15

GuideNum LastName FirstName Address State PostalCode PhoneNum HireDate City Miles 54 Quest Ave. 140 Oakton Rd. 25 Old Ra

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 85% (7 reviews)

Data files consist of copies of the TAL Distributors Colonial Adventure Tours and Solmaris Condominium Group databases that are usable in Access 2010 ...View the full answer

Answered By

Atuga Nichasius

I am a Highly skilled Online Tutor has a Bachelor’s Degree in Engineering as well as seven years of experience tutoring students in high school, bachelors and post graduate levels. I have a solid understanding of all learning styles as well as using asynchronous online platforms for tutoring needs. I individualise tutoring for students according to content tutoring needs assessments. My strengths include good understanding of all teaching methods and learning styles and I am able to convey material to students in an easy to understand manner. I can also assists students with homework questions and test preparation strategies and I am able to help students in math, gre, business , and statistics I consider myself to have excellent interpersonal and assessment skills with strong teaching presentation verbal and written communication I love tutoring. I love doing it. I find it intrinsically satisfying to see the light come on in a student's eyes. My first math lesson that I taught was when I was 5. My neighbor, still in diapers, kept skipping 4 when counting from 1 to 10. I worked with him until he could get all 10 numbers in a row, and match them up with his fingers. My students drastically improve under my tutelage, generally seeing a two grade level improvement (F to C, C to A, for example), and all of them get a much clearer understanding! I am committed to helping my students get the top grades no matter the cost. I will take extra hours with you, repeat myself a thousand times if I have to and guide you to the best of my ability until you understand the concept that I'm teaching you.

5.00+ 2+ Reviews 10+ Question Solved

Related Book For book-img-for-question

Concepts of Database Management

ISBN: 978-1285427102

8th edition

Authors: Philip J. Pratt, Mary Z. Last

See More Books

Question Posted: Dec 21, 2018 06:47 AM

See More Questions

Answer each of the following questions using the Colonial Adventure Tours data shown in Figures 1-15 through

Question:

Step by Step Answer:

Data files consist of copies of the TAL Distributors Colonial Adventure Tours and Solmaris Condominium Group databases that are usable in Access 2010 ...View the full answer

Concepts of Database Management

Students also viewed these Computer science questions