Currently, each trip is identified with only season. For example, the Arethusa Falls trip is offered only in the Summer season. Colonial Adventure Tours is considering offering the same trip in more than one season; that is, the Arethusa Falls trip could be offered in both the Summer and Late Spring seasons. Using this new information, identify all dependencies and convert the current Trip table to third normal form. You may need to make some assumptions. Identify these assumptions in your solution.

Trip TrplD TripName StartLocation State Distance MaxGrpSize Type Season Harts Location 1 Arethusa Falls, 10 Hiking 2 Mt Ascutney North Peak Weathersfield 6 Hiking Late Spring NTT Mit Ascultney West Peak Weathersfield 10 Hiking Early Fall 4 Bradbury Mountain Ride Lewiston-Auburn ME 25 8 Biking Early Fall 10 Hiking Late Spring 5 Baldpate Mountain North Newry Hiking Early Fall Blueberry Mountain ME 8 lders Grant 6 Paddling Late Spring Bloomfield Maidstone Bloomfield 8 Black Pond 12 Hiking 9 Big Rock Cave Tamworth 10 Hiking Summer 10 Mt. Cardigan Firescrew Orange 8 Hiking 11 Chocorua Lake Tour NH 12 Paddling Summer 12 Cadillac Mountain Ride Bar Harbor ME 16 Biking Early Fall 13 Cadillac Mountain Bar Harbor ME 8 Hiking Late Spring Cannon Muna Franconia 6 Hiking Early Fall 14 15 Crawford Path Presidentials Hike Crawford Notch NH 4 Hiking 16 16 Cherry Pond Whitefield NH 16 Hiking Spring 17 Huguenot Head Hike Bar Harbor ME 10 Hiking Early Fall 18 Low Bald Spot Hike Hiking Early Fall Pinkam Notch NH North Stratford 19 Mason's Farm 12 Paddling Late Spring 20 Lake Mephremagog Tour Newport 15 Paddling Late Spring I 21 Long Pond Rutland MA 12 Hiking 22 Long Pond Tour Greenville ME 12 10 Paddling Summer 23 Lower Pond Tour ME 15 Paddling Late Spring 24 Mt Adams. Randolph 6 Hiking 25 Mount Battie Ride 8 Biking Early Fall 20 26 Mount Cardigan Hike Cardigan NH 16 Hiking Late Fall 27 Mt. Chocorua. Albany 10 Hiking Spring 28 Mount Garfield Hike Woodstock 10 Hiking Early Fall A 10 12 Hiking Late Spring Metacomet-Monadnock Trail Hike Pelham 30 McLennan Reservation Hike Tyringham 16 Hiking Summer 12 31 Missisquoi River VT 10 Paddling Summer 32 Northern Forest Canoe Trail Stark NH 15 10 Paddling Summer 33 Park Loop Ride Mount Desert Island ME 8 Biking Late Spring 27 34 Pontook Reservoir Tour Dummer NH 15 14 Paddling Late Spring Pisgah State Park Ride Northborough NH 12 10 Biking 36 White Mountains 16 Biking Late Spring Pondicherry Trail Ride 15 16 Hiking Early Spring 37 Seal Beach Harbor Bar Harbor Sawyer River Ride 18 Biking Early Fall Mount Carrigain 39 Welch and Dickey Mountains Hike Thorton NH 10 Hiking Wachusett Mountain MA 8 Hiking Early Spring ME 41 Westfield River Loop Fort Fairfield 10 Biking Late Spring