Question

1 Approved Answer

Posted on Sep 21, 2024

Please helps! PLEASE DO QUESTION 1- 6. Thank you! The owner of Colonial Adventure Tours would like you to complete the following tasks to help

image text in transcribed Please helps! PLEASE DO QUESTION 1- 6. Thank you!

The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1. (If you use a computer to complete these exercises, use a copy of the original Colonial Adventure Tours database so your data will not reflect the changes you made in Chapter 3.) If you have access to a DBMS, use the DBMS to perform the tasks and explain the steps you used in the process. If not, explain how you would use SQL to obtain the desired results. Check with your instructor if you are uncertain about which approach to take.

7) Ensure that the following are foreign keys (that is, specify referential integrity within the Colonial Adventure Tours database). CustomerNum is a foreign key in the Reservation table. TripID is a foreign key in the Reservation table.

Change the value in the Waiver field in the Customer table to Y for the customer with the last name of Ocean.
Change the length of the StartLocation field in the Trip table to 60.
What command would you use to delete the Trip table from the Colonial Adventure Tours database? (Do not delete the Trip table.)
If you are using Access 2016, complete the following steps.
1. 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.
2. Create a data macro associated with the After Insert event for the Reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the Reservation table. Test the data macro by adding a record to the Reservation table and ensuring that the corresponding customers previous trip total is updated correctly.
3. Create a data macro associated with the After Delete event for the Reservation table to subtract one on the record being deleted from the customers previous trip total. Test the data macro by deleting a record from the Reservation table and ensuring that the corresponding customers previous trip total is updated correctly.
In Question 7, you specified referential integrity for the Reservation table. What other table(s) in the Colonial Adventure Tours database require that you specify referential integrity? Identify the foreign keys in the table(s).
Review the trip data for Colonial Adventure Tours shown in Figure 1-16 on page 17. In addition to the integrity constraint specified in Question 6, what other integrity constraints could you add to at least two other fields in the Trip table?

NH NH Trip TriplD TripName StartLocation State Distance MaxGrpSize Type Season 1 Arethusa Falls Harts Location NH 5 10 Hiking Summer 2 Mt Ascutney - North Peak Weathersfield VT 5 6 Hiking Late Spring 3. Mt Ascutney - West Peak Weathersfield VT 6 10 Hiking Early Fall 4 Bradbury Mountain Ride Lewiston-Auburn ME 25 & Biking Early Fall 5 Baldpate Mountain North Newry ME 6 10 Hiking Late Spring 6 Blueberry Mountain Batchelders Grant ME 8 8 Hiking Early Fall 7 Bloomfield - Maidstone Bloomfield 10 6 Paddling Late Spring 8 Black Pond Lincoln 8 12 Hiking Summer 9 Big Rock Cave Tamworth NH 6 10 Hiking Summer 10 Mt. Cardigan - Firescrew Orange NH 7 8 Hiking Summer 11 Chocorua Lake Tour Tamworth NH 12 15 Paddling Summer 12 Cadillac Mountain Ride Bar Harbor ME 8 16 Biking Early Fall 13 Cadillac Mountain Bar Harbor ME 7 8 Hiking Late Spring 14 Cannon Mtn Franconia 6 6 Hiking Early Fall 15 Crawford Path Presidentials Hike Crawford Notch NH 16 4 Hiking Summer 16 Cherry Pond Whitefield NH 6 16 Hiking Spring 17 Huguenot Head Hike Bar Harbor ME 5 10 Hiking Early Fall 18 Low Bald Spot Hike Pinkam Notch NH 8 6 Hiking Early Fall 19 Mason's Farm North Stratford 12 7 Paddling Late Spring 20 Lake Mephremagog Tour Newport VT 8 15 Paddling Late Spring 21 Long Pond Rutland MA 8 12 Hiking Summer 22 Long Pond Tour Greenville ME 12 10 Paddling Summer 23 Lower Pond Tour Poland ME 8 15 Paddling Late Spring 24 Mt Adams Randolph NH 9 6 Hiking Summer 25 Mount Battie Ride Camden ME 20 8 Biking Early Fall 26 Mount Cardigan Hike Cardigan NH 4 16 Hiking Late Fall 27 Mt. Chocorua Albany 6 10 Hiking Spring 28 Mount Garfield Hike Woodstock NH 5 10 Hiking Early Fall 29 Mctacomet-Monadnock Trail Hike Pelham MA 10 12 Hiking Late Spring 30 McLennan Reservation Hike Tyringham MA 6 16 Hiking Summer 31 Missisquoi River - VT Lowell VT 12 10 Paddling Summer 32 Northern Forest Canoe Trail Stark NH 15 10 Paddling Summer 33 Park Loop Ride Mount Desert Island ME 27 8 Biking Late Spring 34 Pontook Reservoir Tour Dummer NH 14 Paddling Late Spring 35 Pisgah State Park Ride Northborough NH 12 10 Biking Summer 36 Pondicherry Trail Ride White Mountains NH 15 16 Biking Late Spring 37 Seal Beach Harbor Bar Harbor ME 5 16 Hiking Early Spring 38 Sawyer River Ride Mount Carrigain NH 10 18 Biking Farly Fall 39 Welch and Dickey Mountains Hike Thorton NH 5 10 Hiking Summer 40 Wachusett Mountain Princeton MA 8 8 Hiking Early Spring 41 Westfield River Loop Fort Fairfield ME 20 10 Biking Late Spring FIGURE 1-16 Sample trip data for Colonial Adventure Tours NH 15 Phone Num HireDate Guide Guide Num LastName FirstName Address city State Zip Code : Abrams Miles 54 Quest Ave. Williamsburg MA 01096 BRO: Boyers Rita 140 Oakton Rd Jaffrey NH 03452 DHO Devon Harley 25 Old Ranch Rd. Sunderland MA 01375 GZ01 Gregory Zach 7 Moose Head Rd. Dummer NH 03588 KS01 Kiley Susan 943 Oakton Rd Jaffrey NH | 03452 KSO2 Kelly Sam 9 Congaree Ave. Fraconia NH 03580 MROI Marston Ray 24 Shenandoah Rd. Springfield MA 01101 RHOI Rowan Hal 12 Heather Rd Mount Desert ME 04660 SL01 Stevens Lori 15 Riverton Rd Coventry VT 05825 UG01 Unser Glory 342 Pineview St. Danbury CT 06810 617-555-6032 6/3/2012 603-555-2134 3/4/2012 781-555-7767 1/8/2017 603-555-8765 11/4/2013 603-555-1230 4/8/2016 603-555-0003 6/10/2016 781-555-2323 9/14/2015 207-555-9009 6/2/2014 9/5/2014 802-555-3339 203-555-8534 2/2/2017 FIGURE 1-15 Sample guide data for Colonial Adventure Tours Customer CustomerNum LastName FirstName Address City State Zip Code 101 Northfold Liam 1985 Highway 17 N. Londonderry NH 03053 102 Ocean Arnold 2332 South St. Apt 3 Springfield MA 01101 103 Kasuma Sujata 132 Main St. #1 East Hartford CT 06108 104 Goff Ryan 164A South Bend Rd. Lwell MA 01854 105 McLean Kyle 345 Lower Ave. Wolcott NY 14590 106 Morontoia Joseph 156 Scholar St. Johnston RI 02919 107 Marchand Quinn 76 Cross Rd. Bath NH 03740 TOS Rull Uschi 32 Sheep Stop St. Edinboro PA 16412 109 Caron Jean Luc 10 Greenfield St. Rome ME 04963 110 Bers Martha 65 Granite Su York NY 14592 112 Jones Laura 373 Highland Ave. Somerville MA 02143 115 Vaccari Adam 1282 Ocean Walk Ocean City NJ 08226 116 Murakami 7 Cherry Blossom S. Weymouth MA 02188 119 Chau Clement 18 Ark Ledge In Londonderry VT 05148 120 Sadie 24 Stump Rd. Athens ME 04912 121 Bretton-Borak Siam 10 Old Main St. Cambridge VT 05444 122 Hefferson Orlauh 132 South St. Api27 Manchester NH 03101 123 Barnett Larry 25 Stag Rd. Fairfield CT 06824 124 Busa Karen 12 Foster St. South Windsor CT 06074 125 Peterson Becca 51 Fredrick St. Albion NY 14411 126 Brown Brianne 154 Central St. Vernon 06066 Phone 603-555-7563 413-555-3212 860-555-0703 781-555-8423 585-555-5321 401-555-4848 603-555-0456 814-555-5521 207-555-9643 585-555-0111 857-555-6258 609-555-5231 617-555-6665 802-555-3096 207-555-450 802-555-3443 603-555-3476 860-555-9876 857-555-5532 585-555-0900 860-555-3234 FIGURE 1-17 Sample customer data for Colonial Adventure Tours Reservation ReservationID TripID Trip Date 1800001 40 3/26/2018 1800002 21 6/8/2018 1800003 28 9/12/2018 1800004 26 10/16/2018 1800005 39 6/25/2018 1800006 32 6/18/2018 1800007 22 7/9/2018 1800008 28 9/12/2018 1800009 38 9/11/2018 1800010 2 5/14/2018 1800011 3 9/15/2018 1800012 1 6/12/2018 1800013 8 7/9/2018 1800014 12 10/1/2018 1800015 10 7/23/2018 1800016 11 7/23/2018 1800017 39 6/18/2018 1800018 38 9/18/2018 1800019 25 8/29/2018 1800020 28 8/27/2018 1800021 32 6/11/2018 1800022 21 6/8/2018 1800024 38 9/11/2018 1800025 38 9/11/2018 1800026 12 10/1/2018 1800029 4 9/19/2018 1800030 15 7/25/2018 NumPersons Trip Price OtherFees CustomerNum 2 $55.00 $0.00 101 2 $95.00 $0.00 101 1 $35.00 $0.00 103 4 $45.00 $15.00 104 5 $55.00 $0.00 105 1 $80.00 $20.00 106 8 $75.00 $10.00 107 2 $35.00 $0.00 108 2 $90.00 $40.00 109 3 $25.00 $0.00 102 3 $25.00 $0.00 102 4 $15.00 $0.00 115 1 $20.00 $5.00 116 2 $40.00 $5.00 119 1 $20.00 $0.00 120 6 $75.00 $15.00 121 3 $20.00 $5.00 122 4 $85.00 $15.00 126 2 $110.00 $25.00 124 2 $35.00 $10.00 124 3 $90.00 $20.00 112 1 $95.00 $25.00 119 1 $70.00 $30.00 121 2 $70.00 $45.00 125 2 $40.00 $0.00 126 4 $105.00 $25.00 120 6 $60.00 $15.00 104 FIGURE 1-18 Sample reservations data for Colonial Adventure Tours Trip Guides TriplD GuideNum 1 GZ01 1 RH01 2 AM01 2 SL01 3 SL01 4 BRO1 4 GZ01 5 KS01 5 UG01 6 RH01 7 SL01 8 BRO1 9 BRO1 10 GZ01 DH01 KS01 11 UG01 12 BRO1 13 RH01 14 KS02 15 GZ01 16 KSO2 17 RH01 18 KSO2 Trip Guides (continued) TriplD GuideNum 19 DH01 20 SL01 21 AM01 22 UG01 23 DH01 23 SL01 24 BRO1 25 BRO1 26 GZ01 27 GZ01 28 BRO1 29 DH01 30 AM01 31 SL01 32 KS01 33 UG01 34 KS01 35 GZ01 36 KS02 37 RHO1 38 KSO2 39 BRO1 40 DH01 41 BR01 11 11 FIGURE 1-19 Table used to relate trips and guides NH NH Trip Triplo Trip Name StartLocation State Distance MaxGrpSize Type Season 1 Arethusa Falls Harts Location NH 5 10 Hiking Summer 2 Mt Ascutney - North Peak Weathersfield VT 5 6 Hiking Late Spring 3 Mt Ascutney - West Peak Weathersfield VT 6 10 Hiking Early Fall 4 Bradbury Mountain Ride Lewiston-Auburn ME 25 8 Biking Early Fall 5 Baldpate Mountain North Newry ME 6 10 Hiking Late Spring 6 Blueberry Mountain Batchelders Grant ME 8 8 Hiking Early Fall 7 Bloomfield - Maidstone Bloomficla 10 6 Paddling Late Spring 8 Black Pond Lincoln 8 12 Hiking Summer 9 Big Rock Cave Tamworth NH 6 10 Hiking Summer 10 Mt Cardigan - Firescrew Orange NH 7 8 Hiking Summer 11 Chocorua Lake Tour Tamworth NH 12 15 Paddling Summer 12 Cadillac Mountain Ride Bar Harbor ME 8 16 Biking Early Fall 13 Cadillac Mountain Bar Harbor ME 7 8 Hiking Late Spring 14 Cannon Mtn Franconia 6 6 Hiking Early Fall 15 Crawford Path Presidentials Hike Crawford Notch NH 16 4 Hiking Summer 16 Cherry Pond Whitefield NH 6 16 Hiking Spring 17 Huguenot Head Hike Bar Harbor ME 5 10 Hiking Early Fall 18 Low Bald Spot Hike Pinkam Notch NH 8 6 Hiking Early Fall 19 Mason's Farm North Stratford 12 7 Paddling Late Spring 20 Lake Mephremagog Tour Newport VT 8 15 Paddling Late Spring 21 Long Pond Rutland MA 8 12 Hiking Summer 22 Long Pond Tour Greenville ME 12 10 Paddling Summer 23 Lower Pond Tour Poland ME 8 15 Paddling Late Spring 24 Mt Adams Randolph NH 9 6 Hiking Summer 25 Mount Battie Ride Camden ME 20 8 Biking Early Fall 26 Mount Cardigan Hike Cardigan NH 4 16 Hiking Late Fall 27 Mt. Chocorua Albany 6 10 Hiking Spring 28 Mount Garfield Hike Woodstock NH 5 10 Hiking Early Fall 29 Metacomet-Monadnock Trail Hike Pelham MA 10 12 Hiking Late Spring 30. McLennan Reservation Hike Tyringham MA 6 16 Hiking Summer 31 Missisquoi River - VT Lowell VT 10 Paddling Summer 32 Northern Forest Canoe Trail Stark NH 15 10 Paddling Summer 33 Park Loop Ride Mount Desert Island ME 27 8 Biking Late Spring 34 Pontook Reservoir Tour Dummer NH 15 14 Paddling Late Spring 35 Pisgah State Park Ride Northborough NH 12 10 Biking Summer 36 Pondicherry Trail Ride White Mountains NH 15 16 Biking Late Spring 37 Seal Beach Harbor Bar Harbor ME 5 16 Hiking Early Spring 38 Sawyer River Ride Mount Carrigain NH 10 18 Biking Early Fall 39 Welch and Dickey Mountains Hike Thorton NH 5 10 Hiking Summer 40 Wachuseu Mountain Princeton MA 8 8 Hiking Early Spring 41 Westfield River Loop Fort Fairfield ME 20 10 Biking Late Spring FIGURE 1-16 Sample trip data for Colonial Adventure Tours NH 12 NH NH Trip TriplD TripName StartLocation State Distance MaxGrpSize Type Season 1 Arethusa Falls Harts Location NH 5 10 Hiking Summer 2 Mt Ascutney - North Peak Weathersfield VT 5 6 Hiking Late Spring 3. Mt Ascutney - West Peak Weathersfield VT 6 10 Hiking Early Fall 4 Bradbury Mountain Ride Lewiston-Auburn ME 25 & Biking Early Fall 5 Baldpate Mountain North Newry ME 6 10 Hiking Late Spring 6 Blueberry Mountain Batchelders Grant ME 8 8 Hiking Early Fall 7 Bloomfield - Maidstone Bloomfield 10 6 Paddling Late Spring 8 Black Pond Lincoln 8 12 Hiking Summer 9 Big Rock Cave Tamworth NH 6 10 Hiking Summer 10 Mt. Cardigan - Firescrew Orange NH 7 8 Hiking Summer 11 Chocorua Lake Tour Tamworth NH 12 15 Paddling Summer 12 Cadillac Mountain Ride Bar Harbor ME 8 16 Biking Early Fall 13 Cadillac Mountain Bar Harbor ME 7 8 Hiking Late Spring 14 Cannon Mtn Franconia 6 6 Hiking Early Fall 15 Crawford Path Presidentials Hike Crawford Notch NH 16 4 Hiking Summer 16 Cherry Pond Whitefield NH 6 16 Hiking Spring 17 Huguenot Head Hike Bar Harbor ME 5 10 Hiking Early Fall 18 Low Bald Spot Hike Pinkam Notch NH 8 6 Hiking Early Fall 19 Mason's Farm North Stratford 12 7 Paddling Late Spring 20 Lake Mephremagog Tour Newport VT 8 15 Paddling Late Spring 21 Long Pond Rutland MA 8 12 Hiking Summer 22 Long Pond Tour Greenville ME 12 10 Paddling Summer 23 Lower Pond Tour Poland ME 8 15 Paddling Late Spring 24 Mt Adams Randolph NH 9 6 Hiking Summer 25 Mount Battie Ride Camden ME 20 8 Biking Early Fall 26 Mount Cardigan Hike Cardigan NH 4 16 Hiking Late Fall 27 Mt. Chocorua Albany 6 10 Hiking Spring 28 Mount Garfield Hike Woodstock NH 5 10 Hiking Early Fall 29 Mctacomet-Monadnock Trail Hike Pelham MA 10 12 Hiking Late Spring 30 McLennan Reservation Hike Tyringham MA 6 16 Hiking Summer 31 Missisquoi River - VT Lowell VT 12 10 Paddling Summer 32 Northern Forest Canoe Trail Stark NH 15 10 Paddling Summer 33 Park Loop Ride Mount Desert Island ME 27 8 Biking Late Spring 34 Pontook Reservoir Tour Dummer NH 14 Paddling Late Spring 35 Pisgah State Park Ride Northborough NH 12 10 Biking Summer 36 Pondicherry Trail Ride White Mountains NH 15 16 Biking Late Spring 37 Seal Beach Harbor Bar Harbor ME 5 16 Hiking Early Spring 38 Sawyer River Ride Mount Carrigain NH 10 18 Biking Farly Fall 39 Welch and Dickey Mountains Hike Thorton NH 5 10 Hiking Summer 40 Wachusett Mountain Princeton MA 8 8 Hiking Early Spring 41 Westfield River Loop Fort Fairfield ME 20 10 Biking Late Spring FIGURE 1-16 Sample trip data for Colonial Adventure Tours NH 15 Phone Num HireDate Guide Guide Num LastName FirstName Address city State Zip Code : Abrams Miles 54 Quest Ave. Williamsburg MA 01096 BRO: Boyers Rita 140 Oakton Rd Jaffrey NH 03452 DHO Devon Harley 25 Old Ranch Rd. Sunderland MA 01375 GZ01 Gregory Zach 7 Moose Head Rd. Dummer NH 03588 KS01 Kiley Susan 943 Oakton Rd Jaffrey NH | 03452 KSO2 Kelly Sam 9 Congaree Ave. Fraconia NH 03580 MROI Marston Ray 24 Shenandoah Rd. Springfield MA 01101 RHOI Rowan Hal 12 Heather Rd Mount Desert ME 04660 SL01 Stevens Lori 15 Riverton Rd Coventry VT 05825 UG01 Unser Glory 342 Pineview St. Danbury CT 06810 617-555-6032 6/3/2012 603-555-2134 3/4/2012 781-555-7767 1/8/2017 603-555-8765 11/4/2013 603-555-1230 4/8/2016 603-555-0003 6/10/2016 781-555-2323 9/14/2015 207-555-9009 6/2/2014 9/5/2014 802-555-3339 203-555-8534 2/2/2017 FIGURE 1-15 Sample guide data for Colonial Adventure Tours Customer CustomerNum LastName FirstName Address City State Zip Code 101 Northfold Liam 1985 Highway 17 N. Londonderry NH 03053 102 Ocean Arnold 2332 South St. Apt 3 Springfield MA 01101 103 Kasuma Sujata 132 Main St. #1 East Hartford CT 06108 104 Goff Ryan 164A South Bend Rd. Lwell MA 01854 105 McLean Kyle 345 Lower Ave. Wolcott NY 14590 106 Morontoia Joseph 156 Scholar St. Johnston RI 02919 107 Marchand Quinn 76 Cross Rd. Bath NH 03740 TOS Rull Uschi 32 Sheep Stop St. Edinboro PA 16412 109 Caron Jean Luc 10 Greenfield St. Rome ME 04963 110 Bers Martha 65 Granite Su York NY 14592 112 Jones Laura 373 Highland Ave. Somerville MA 02143 115 Vaccari Adam 1282 Ocean Walk Ocean City NJ 08226 116 Murakami 7 Cherry Blossom S. Weymouth MA 02188 119 Chau Clement 18 Ark Ledge In Londonderry VT 05148 120 Sadie 24 Stump Rd. Athens ME 04912 121 Bretton-Borak Siam 10 Old Main St. Cambridge VT 05444 122 Hefferson Orlauh 132 South St. Api27 Manchester NH 03101 123 Barnett Larry 25 Stag Rd. Fairfield CT 06824 124 Busa Karen 12 Foster St. South Windsor CT 06074 125 Peterson Becca 51 Fredrick St. Albion NY 14411 126 Brown Brianne 154 Central St. Vernon 06066 Phone 603-555-7563 413-555-3212 860-555-0703 781-555-8423 585-555-5321 401-555-4848 603-555-0456 814-555-5521 207-555-9643 585-555-0111 857-555-6258 609-555-5231 617-555-6665 802-555-3096 207-555-450 802-555-3443 603-555-3476 860-555-9876 857-555-5532 585-555-0900 860-555-3234 FIGURE 1-17 Sample customer data for Colonial Adventure Tours Reservation ReservationID TripID Trip Date 1800001 40 3/26/2018 1800002 21 6/8/2018 1800003 28 9/12/2018 1800004 26 10/16/2018 1800005 39 6/25/2018 1800006 32 6/18/2018 1800007 22 7/9/2018 1800008 28 9/12/2018 1800009 38 9/11/2018 1800010 2 5/14/2018 1800011 3 9/15/2018 1800012 1 6/12/2018 1800013 8 7/9/2018 1800014 12 10/1/2018 1800015 10 7/23/2018 1800016 11 7/23/2018 1800017 39 6/18/2018 1800018 38 9/18/2018 1800019 25 8/29/2018 1800020 28 8/27/2018 1800021 32 6/11/2018 1800022 21 6/8/2018 1800024 38 9/11/2018 1800025 38 9/11/2018 1800026 12 10/1/2018 1800029 4 9/19/2018 1800030 15 7/25/2018 NumPersons Trip Price OtherFees CustomerNum 2 $55.00 $0.00 101 2 $95.00 $0.00 101 1 $35.00 $0.00 103 4 $45.00 $15.00 104 5 $55.00 $0.00 105 1 $80.00 $20.00 106 8 $75.00 $10.00 107 2 $35.00 $0.00 108 2 $90.00 $40.00 109 3 $25.00 $0.00 102 3 $25.00 $0.00 102 4 $15.00 $0.00 115 1 $20.00 $5.00 116 2 $40.00 $5.00 119 1 $20.00 $0.00 120 6 $75.00 $15.00 121 3 $20.00 $5.00 122 4 $85.00 $15.00 126 2 $110.00 $25.00 124 2 $35.00 $10.00 124 3 $90.00 $20.00 112 1 $95.00 $25.00 119 1 $70.00 $30.00 121 2 $70.00 $45.00 125 2 $40.00 $0.00 126 4 $105.00 $25.00 120 6 $60.00 $15.00 104 FIGURE 1-18 Sample reservations data for Colonial Adventure Tours Trip Guides TriplD GuideNum 1 GZ01 1 RH01 2 AM01 2 SL01 3 SL01 4 BRO1 4 GZ01 5 KS01 5 UG01 6 RH01 7 SL01 8 BRO1 9 BRO1 10 GZ01 DH01 KS01 11 UG01 12 BRO1 13 RH01 14 KS02 15 GZ01 16 KSO2 17 RH01 18 KSO2 Trip Guides (continued) TriplD GuideNum 19 DH01 20 SL01 21 AM01 22 UG01 23 DH01 23 SL01 24 BRO1 25 BRO1 26 GZ01 27 GZ01 28 BRO1 29 DH01 30 AM01 31 SL01 32 KS01 33 UG01 34 KS01 35 GZ01 36 KS02 37 RHO1 38 KSO2 39 BRO1 40 DH01 41 BR01 11 11 FIGURE 1-19 Table used to relate trips and guides NH NH Trip Triplo Trip Name StartLocation State Distance MaxGrpSize Type Season 1 Arethusa Falls Harts Location NH 5 10 Hiking Summer 2 Mt Ascutney - North Peak Weathersfield VT 5 6 Hiking Late Spring 3 Mt Ascutney - West Peak Weathersfield VT 6 10 Hiking Early Fall 4 Bradbury Mountain Ride Lewiston-Auburn ME 25 8 Biking Early Fall 5 Baldpate Mountain North Newry ME 6 10 Hiking Late Spring 6 Blueberry Mountain Batchelders Grant ME 8 8 Hiking Early Fall 7 Bloomfield - Maidstone Bloomficla 10 6 Paddling Late Spring 8 Black Pond Lincoln 8 12 Hiking Summer 9 Big Rock Cave Tamworth NH 6 10 Hiking Summer 10 Mt Cardigan - Firescrew Orange NH 7 8 Hiking Summer 11 Chocorua Lake Tour Tamworth NH 12 15 Paddling Summer 12 Cadillac Mountain Ride Bar Harbor ME 8 16 Biking Early Fall 13 Cadillac Mountain Bar Harbor ME 7 8 Hiking Late Spring 14 Cannon Mtn Franconia 6 6 Hiking Early Fall 15 Crawford Path Presidentials Hike Crawford Notch NH 16 4 Hiking Summer 16 Cherry Pond Whitefield NH 6 16 Hiking Spring 17 Huguenot Head Hike Bar Harbor ME 5 10 Hiking Early Fall 18 Low Bald Spot Hike Pinkam Notch NH 8 6 Hiking Early Fall 19 Mason's Farm North Stratford 12 7 Paddling Late Spring 20 Lake Mephremagog Tour Newport VT 8 15 Paddling Late Spring 21 Long Pond Rutland MA 8 12 Hiking Summer 22 Long Pond Tour Greenville ME 12 10 Paddling Summer 23 Lower Pond Tour Poland ME 8 15 Paddling Late Spring 24 Mt Adams Randolph NH 9 6 Hiking Summer 25 Mount Battie Ride Camden ME 20 8 Biking Early Fall 26 Mount Cardigan Hike Cardigan NH 4 16 Hiking Late Fall 27 Mt. Chocorua Albany 6 10 Hiking Spring 28 Mount Garfield Hike Woodstock NH 5 10 Hiking Early Fall 29 Metacomet-Monadnock Trail Hike Pelham MA 10 12 Hiking Late Spring 30. McLennan Reservation Hike Tyringham MA 6 16 Hiking Summer 31 Missisquoi River - VT Lowell VT 10 Paddling Summer 32 Northern Forest Canoe Trail Stark NH 15 10 Paddling Summer 33 Park Loop Ride Mount Desert Island ME 27 8 Biking Late Spring 34 Pontook Reservoir Tour Dummer NH 15 14 Paddling Late Spring 35 Pisgah State Park Ride Northborough NH 12 10 Biking Summer 36 Pondicherry Trail Ride White Mountains NH 15 16 Biking Late Spring 37 Seal Beach Harbor Bar Harbor ME 5 16 Hiking Early Spring 38 Sawyer River Ride Mount Carrigain NH 10 18 Biking Early Fall 39 Welch and Dickey Mountains Hike Thorton NH 5 10 Hiking Summer 40 Wachuseu Mountain Princeton MA 8 8 Hiking Early Spring 41 Westfield River Loop Fort Fairfield ME 20 10 Biking Late Spring FIGURE 1-16 Sample trip data for Colonial Adventure Tours NH 12