Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / The following exercises are based on the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1

The following exercises are based on the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1

Computer Science

The following exercises are based on the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1. No computer work is required.Guide 
Guklehan LastName RestNem* (5ty =I PostalCoda PhoneNum HimOat* AMO1 Abrams Miles 54 Quest Ave. MA 01096 617-5554032 6/3/2012 Willsamstang BRO1 Boyers Rita 140 Oakum Rd. Jaffrcy NH 03452 603555-2134 3/4/2012 DHO1 Devon Harley 25 Old Ranch Rd. Sunderland MA 01375 781-555-7767 1/8/2012 GZOI Gregory lads 7 Moose Had Rd. bummer NH 03588 6035554765 11/4/2012 KS01 Kiley Swan 943 Oakion Rd. Jaffrey, NH 03452 603-555-1230 4/8/2013 KSCl2 Kelly Sam 9 Congaree Ave. Frassonsa NH 03580 603-555-0003 6/10/2013 MR01 Manton Ray 24 Shenandoah Rd. Sonngfield MA 01101 781.555-2323 9/14/2015 RHO1 Rowan Hal 12 Heather Rd. Mount Mien ME 04660 207-555-9009 6/2/2014 51.01 Stevens Lon 15 Riverton Rd. Coventry VT 05825 802-555-3339 9/5/2014 UGO1 Unser Glory 342 Pineview St. Danbury CT 06810 203-555-8534 2/2/2015 
ricu RE 1-15 Sample guide data for Colonial Adventure Tours 
Trip 
741111 Starthopethen 1:223 Oistance litruCirgeStre Type Season 1 Medlin: Falls Harm Location NH 5 10 Hiking Summer 2 Mt Ascutney - North Peak Weathentirid VT 5 6 Iliking Law Spring 3 Mt Afk11111CY - Peak Weathentiehl VT 6 to Hiking Early Fall 4 Itradhury Mountain Rile Imanton-Auburn ME 25 8 Biking Early Fall Baldpate Mountain North Newry ME 6 10 Hiking Law Spring 6 Illuebeny Mountain IlatelwIders Grant ME S 8 I liking Early Fall 7 - Maidstone Bloondiekt Cr 10 6 Paddling Law Spring 8 Mack Pond Lincoln NII 8 12 Hiking Summer 9 Rag Rock Cave Tamwonli Nil 6 10 Hiking Summer 10 Mt. Cardigan - Firewrew Orange NH 7 S I hkmg Summer 11 UNCOIL] Lake Tour I amworth 12 15 Paddling Summer 12 Cadillac Mmultain Ride Ita: Harbor ME 8 16 Biking Early Fall 13 Cadillac Mountain liar harbor ME 7 8 hiking late Spring 14 Cannon Mtn Franconia NII 6 6 I liking Early Fall 15 (.:ravefivd Path Proaknuals I like Crawford Notch NH 16 4 Hang Summer 16 Cherry Pond \Vivien:1cl NI1 6 16 1 Eking Sprang 17 Huguenot Head Hike Bar Harbor ME 5 10 Inking Early Fall IS Low Bald Spot Hike Pinkam Notch NII 6 Inking Early Fall 19 Mason's harm North Stratford cr 12 7 Paddling late Spring 20 lake Ntephremagog Tour Newport vr 15 Paddling I ate Spring 21 long Pond Rutland MA S 12 Inking Summer 22 long Pond Tour ME 12 10 Paddling Sunnier 23 Lower Pond Tour Poland ME 8 15 Paddling IAN Spring 24 Mt Adams Randolph NH 9 6 Hiking Summer 25 Mount Hattie Ride Camden ME 20 8 Biking Early Fall 26 Mount Cardigan I hke Cardigan 4 16 Hiking Late Fall 27 Sit. Chocatua Albany NII 6 10 Inking Spring 28 Mount Garfield I like Wooduock NH 5 10 I liking Early Fall 29 Nkuconwt-Monadnock Hike Pelham MA 10 12 tlikag Late Spring 30 NELennan Rewn.ation ti l e Tytinglutm MA 6 16 Mang Summer 31 Mnusquin Ricer - Lowell 12 10 Paddling Summer 32 Northern Forest Canoe Trail Stark NI1 15 10 Paddling Summer 33 Park loop Ride Mount Hewn Island ME 27 S Biking Inca Spring 
34 Pant o& Itturvou Tour l)umnicr Nil 15 14 Paddling Litt Spring 35 Pisgah State Park lbdc Nonhborough Nil 12 10 Biking Summer 36 Pondicheny Trail Ride Slountams Nil 15 16 Biking late Spring 37 Seal Reach Harbor Bar I Lubin .ME 5 16 Hiking fatly Spring 38 Sayer River Ride 'doom Clungain Nil IS Biking Early EAU 39 Welch and Dickey Mountain. Ilde llbirton NH 5 10 Ibking Summer 40 Wachuseit Mountun Princeton a S Hiking Early Spring 41 Winiticld River Loop Fort Fairfield ME 20 10 Hiking late Spring 
Customer 
CustomerNum Itisthirme Address Posta/Cede Plume 101 Norilsk.Id Liam 9 Old MI Rd. Londemderry NH 03053 603455-7563 102 Ocean Arnold 2332 South St. AN 3 Spnrudield MA 01101 413455-3212 101 K2SUITU SWata 132 Main St d1 East Itantord CT 06108 860-555-0703 164A South Rend Rd 104 Goff Ryan l4)u& MA 01854 781.555-8423 105 McLean Ksie 345 lower Ace. Wricmt NY 14590 5855554321 106 Morontou Joseph 156 Scholar Si. Johnston RI 02919 401-5554848 107 Marchand Quoin 76 Cross Rd. Bath NH 03740 603-555-0456 108 RuIf Utchi 32 Sheep Stop St. Eduthens PA 16412 8144554521 109 Canto Jean lax 10 Greenfield St Rome ME 04963 207-555-9643 110 Ben Martha 65 Granite St York NY 14592 585-555-0111 112 Jann Laura 37311tgliland Ave. &MKT 1114. MA 02143 857455-6258 115 Vaccan Adam 1282 Ocean Walk Ocean Pity NJ 08226 6094554231 116 .Murakanu Ito 7 Blossom Si. Weymouth MA 02188 617-555-6665 119 Chau Cement 18 Ark ledge In lonsionderry VT 05148 802-5554096 120 Gernowdu Sadao 24 Stump Rd. Athens ME 04912 207.555-4507 121 BrettomItmak SLIT 10 Old Main St. Cunlmdge VT 05444 802-555-3443 122 liciterson Orhuh 132 South St. Apt 27 Manchester NH 03101 603455-3476 123 Barnett Lany 25 Stag Rd Fairfield CT 06824 860-555-9876 124 Bum Karen 12 Foact St. South Washor CT 06074 857-555-5532 125 Peterson Mecca 51 Frednek St. ARnon NY 14411 585-555-0900 126 Broun Brianne 154 Central St. Vernon err 06066 860455-3234 
Sample customer data for Colons/1 Adventure Tours 
Reservation 
RouentIon10 TripData NumPersons OtherFee CustomerNum 600001 40 31260016 2 $55.00 $0.00 101 600002 21 6/80016 2 595.00 $0.00 101 600003 28 9/12/2016 1 $35.00 $0.00 103 600001 26 10/16/2016 4 $45.00 51500 104 600005 39 6/250016 5 555.00 $0.00 105 600006 32 6/18016 580.00 520.00 106 600007 22 7/9/2016 $75.00 $10.00 107 600008 28 9/12/2016 2 $35.00 $0.00 108 600009 38 9/110016 2 $90.00 540.00 109 600010 2 N14a016 3 $25.00 $0.00 102 600011 3 9/15/2016 3 525.00 $0.00 102 600012 N120016 4 515.011 $0.00 115 600013 8 7/90016 1 $20.00 $5.00 116 600014 12 10/1/21M6 2 540.011 $5.00 119 600015 10 7/23/2016 I $20.00 $0.00 120 600016 11 7/22gol6 6 $75.00 $1500 121 600017 39 6/18/2016 3 $70.00 $5.00 122 600018 38 5q1W2016 4 $85.00 515.00 126 600019 25 N29/2016 2 $1 10.00 32500 124 600020 28 W27/2016 2 $35.00 $10.00 124 600021 32 NH/2016 3 590.00 $20.00 Ill 600022 21 6/80016 1 $95.00 $25.00 119 600024 38 9/110016 1 $70.00 $30.00 121 600025 38 9111/2016 2 $70.00 $4500 125 600026 12 ion/2016 2 $40.00 $0.00 126 600029 4 9/19/2016 4 $105.00 $25.00 120 600030 15 7/250016 6 560.00 51500 104 1 Sample reservabons data for Colonial Adventure Tours 
TripGuides TripGuides (continued) 1 I G7.01 RI101 a 19 20 DHOI SLOI 2 AMOI a-21 A3101 2 SI.01 22 UGO1 3 SI.01 23 DHOI 4 BROI 23 SLOT 4 G7.01 24 BRO1 5 KS01 25 BRO1 5 UGOI 26 GZO1 6 RI101 27 GZOI 7 SIA1 28 BRO1 8 BROI 29 DHOI 9 BROI 1=111 30 AMO1 10 G7.01 31 SI.01 11 DHOI 32 KS01 11 KSOI 33 UGO1 11 UGO1 34 KS01 12 BROI 35 G7.01 13 Rt101 36 KS02 14 KS02 37 RHO! 15 G7A1 38 KS02 16 KS02 39 BRO1 17 RHO1 40 DHOI 18 KS02 41 BRO1 
ER; uni: 119 Table used to relate trips and guides 
Using the types of entities found in the Colonial Adventure Tours database (trips, guides, customers, and reservations), create an example of a table that is in first normal form but not in second normal form and an example of a table that is in second normal form but not in third normal form. In each case, justify your answers and show how to convert to the higher forms.

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Related Questions