Assignment p
Solomon Kane
ColonialAdventureToursWeek4.accdb| CUSTOMER_NUM | LAST_NAME | FIRST_NAME | ADDRESS | CITY | STATE | POSTAL_CODE | PHONE |
|---|---|---|---|---|---|---|---|
| 101 | Northfold | Liam | 9 Old Mill Rd. | Londonderry | NH | 03053 | 603-555-7563 |
| 102 | Ocean | Arnold | 2332 South St. Apt 3 | Springfield | MA | 01101 | 413-555-3212 |
| 103 | Kasuma | Sujata | 132 Main St. #1 | East Hartford | CT | 06108 | 860-555-0703 |
| 104 | Goff | Ryan | 164A South Bend Rd. | Lowell | MA | 01854 | 781-555-8423 |
| 105 | McLean | Kyle | 345 Lower Ave. | Wolcott | NY | 14590 | 585-555-5321 |
| 106 | Morontoia | Joseph | 156 Scholar St. | Johnston | RI | 02919 | 401-555-4848 |
| 107 | Marchand | Quinn | 76 Cross Rd. | Bath | NH | 03740 | 603-555-0456 |
| 108 | Rulf | Uschi | 32 Sheep Stop St. | Edinboro | PA | 16412 | 814-555-5521 |
| 109 | Caron | Jean Luc | 10 Greenfield St. | Rome | ME | 04963 | 207-555-9643 |
| 110 | Bers | Martha | 65 Granite St. | York | NY | 14592 | 585-555-0111 |
| 112 | Jones | Laura | 373 Highland Ave. | Somerville | MA | 02143 | 857-555-6258 |
| 115 | Vaccari | Adam | 1282 Ocean Walk | Ocean City | NJ | 08226 | 609-555-5231 |
| 116 | Murakami | Iris | 7 Cherry Blossom St. | Weymouth | MA | 02188 | 617-555-6665 |
| 119 | Chau | Clement | 18 Ark Ledge Ln. | Londonderry | VT | 05148 | 802-555-3096 |
| 120 | Gernowski | Sadie | 24 Stump Rd. | Athens | ME | 04912 | 207-555-4507 |
| 121 | Bretton-Borak | Siam | 10 Old Main St. | Cambridge | VT | 05444 | 802-555-3443 |
| 122 | Hefferson | Orlagh | 132 South St. Apt 27 | Manchester | NH | 03101 | 603-555-3476 |
| 123 | Barnett | Larry | 25 Stag Rd. | Fairfield | CT | 06824 | 860-555-9876 |
| 124 | Busa | Karen | 12 Foster St. | South Windsor | CT | 06074 | 857-555-5532 |
| 125 | Peterson | Becca | 51 Fredrick St. | Albion | NY | 14411 | 585-555-0900 |
| 126 | Brown | Brianne | 154 Central St. | Vernon | CT | 06066 | 860-555-3234 |
| GUIDE_NUM | LAST_NAME | FIRST_NAME | ADDRESS | CITY | STATE | POSTAL_CODE | PHONE_NUM | HIRE_DATE |
|---|---|---|---|---|---|---|---|---|
| AM01 | Abrams | Miles | 54 Quest Ave. | Williamsburg | MA | 01096 | 617-555-6032 | 6/3/12 |
| BR01 | Boyers | Rita | 140 Oakton Rd. | Jaffrey | NH | 03452 | 603-555-2134 | 3/4/12 |
| DH01 | Devon | Harley | 25 Old Ranch Rd. | Sunderland | MA | 01375 | 781-555-7767 | 1/8/12 |
| GZ01 | Gregory | Zach | 7 Moose Head Rd. | Dummer | NH | 03588 | 603-555-8765 | 11/4/12 |
| KS01 | Kiley | Susan | 943 Oakton Rd. | Jaffrey | NH | 03452 | 603-555-1230 | 4/8/13 |
| KS02 | Kelly | Sam | 9 Congaree Ave. | Fraconia | NH | 03580 | 603-555-0003 | 6/10/13 |
| MR01 | Marston | Ray | 24 Shenandoah Rd. | Springfield | MA | 01101 | 781-555-2323 | 9/14/15 |
| RH01 | Rowan | Hal | 12 Heather Rd. | Mount Desert | ME | 04660 | 207-555-9009 | 6/2/14 |
| SL01 | Stevens | Lori | 15 Riverton Rd. | Coventry | VT | 05825 | 802-555-3339 | 9/5/14 |
| UG01 | Unser | Glory | 342 Pineview St. | Danbury | CT | 06810 | 203-555-8534 | 2/2/15 |
| RESERVATION_ID | TRIP_ID | TRIP_DATE | NUM_PERSONS | TRIP_PRICE | OTHER_FEES | CUSTOMER_NUM |
|---|---|---|---|---|---|---|
| 1600001 | 40 | 3/26/16 | 2 | ¤ 55.00 | ¤ 0.00 | 101 |
| 1600002 | 21 | 6/8/16 | 2 | ¤ 95.00 | ¤ 0.00 | 101 |
| 1600003 | 28 | 9/12/16 | 1 | ¤ 35.00 | ¤ 0.00 | 103 |
| 1600004 | 26 | 10/16/16 | 4 | ¤ 45.00 | ¤ 15.00 | 104 |
| 1600005 | 39 | 6/25/16 | 5 | ¤ 55.00 | ¤ 0.00 | 105 |
| 1600006 | 32 | 6/18/16 | 1 | ¤ 80.00 | ¤ 20.00 | 106 |
| 1600007 | 22 | 7/9/16 | 8 | ¤ 75.00 | ¤ 10.00 | 107 |
| 1600008 | 28 | 9/12/16 | 2 | ¤ 35.00 | ¤ 0.00 | 108 |
| 1600009 | 38 | 9/11/16 | 2 | ¤ 90.00 | ¤ 40.00 | 109 |
| 1600010 | 2 | 5/14/16 | 3 | ¤ 25.00 | ¤ 0.00 | 102 |
| 1600011 | 3 | 9/15/16 | 3 | ¤ 25.00 | ¤ 0.00 | 102 |
| 1600012 | 1 | 6/12/16 | 4 | ¤ 15.00 | ¤ 0.00 | 115 |
| 1600013 | 8 | 7/9/16 | 1 | ¤ 20.00 | ¤ 5.00 | 116 |
| 1600014 | 12 | 10/1/16 | 2 | ¤ 40.00 | ¤ 5.00 | 119 |
| 1600015 | 10 | 7/23/16 | 1 | ¤ 20.00 | ¤ 0.00 | 120 |
| 1600016 | 11 | 7/23/16 | 6 | ¤ 75.00 | ¤ 15.00 | 121 |
| 1600017 | 39 | 6/18/16 | 3 | ¤ 20.00 | ¤ 5.00 | 122 |
| 1600018 | 38 | 9/18/16 | 4 | ¤ 85.00 | ¤ 15.00 | 126 |
| 1600019 | 25 | 8/29/16 | 2 | ¤ 110.00 | ¤ 25.00 | 124 |
| 1600020 | 28 | 8/27/16 | 2 | ¤ 35.00 | ¤ 10.00 | 124 |
| 1600021 | 32 | 6/11/16 | 3 | ¤ 90.00 | ¤ 20.00 | 112 |
| 1600022 | 21 | 6/8/16 | 1 | ¤ 95.00 | ¤ 25.00 | 119 |
| 1600024 | 38 | 9/11/16 | 1 | ¤ 70.00 | ¤ 30.00 | 121 |
| 1600025 | 38 | 9/11/16 | 2 | ¤ 70.00 | ¤ 45.00 | 125 |
| 1600026 | 12 | 10/1/16 | 2 | ¤ 40.00 | ¤ 0.00 | 126 |
| 1600029 | 4 | 9/19/16 | 4 | ¤ 105.00 | ¤ 25.00 | 120 |
| 1600030 | 15 | 7/25/16 | 6 | ¤ 60.00 | ¤ 15.00 | 104 |
| TRIP_ID | TRIP_NAME | START_LOCATION | STATE | DISTANCE | MAX_GRP_SIZE | 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 | Bloomfield | CT | 10 | 6 | Paddling | Late Spring |
| 8 | Black Pond | Lincoln | NH | 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 | NH | 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 | CT | 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 | NH | 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 | 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 | 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 | Wachusett Mountain | Princeton | MA | 8 | 8 | Hiking | Early Spring |
| 41 | Westfield River Loop | Fort Fairfield | ME | 20 | 10 | Biking | Late Spring |
| TRIP_ID | GUIDE_NUM |
|---|---|
| 1 | GZ01 |
| 1 | RH01 |
| 2 | AM01 |
| 2 | SL01 |
| 3 | SL01 |
| 4 | BR01 |
| 4 | GZ01 |
| 5 | KS01 |
| 5 | UG01 |
| 6 | RH01 |
| 7 | SL01 |
| 8 | BR01 |
| 9 | BR01 |
| 10 | GZ01 |
| 11 | DH01 |
| 11 | KS01 |
| 11 | UG01 |
| 12 | BR01 |
| 13 | RH01 |
| 14 | KS02 |
| 15 | GZ01 |
| 16 | KS02 |
| 17 | RH01 |
| 18 | KS02 |
| 19 | DH01 |
| 20 | SL01 |
| 21 | AM01 |
| 22 | UG01 |
| 23 | DH01 |
| 23 | SL01 |
| 24 | BR01 |
| 25 | BR01 |
| 26 | GZ01 |
| 27 | GZ01 |
| 28 | BR01 |
| 29 | DH01 |
| 30 | AM01 |
| 31 | SL01 |
| 32 | KS01 |
| 33 | UG01 |
| 34 | KS01 |
| 35 | GZ01 |
| 36 | KS02 |
| 37 | RH01 |
| 38 | KS02 |
| 39 | BR01 |
| 40 | DH01 |
| 41 | BR01 |
