Ho can I make the TRIP_GUIDES table like the figure 1.8?

Sample Guide Data for Colonial Adventure Tours GUIDE CITY STATE POSTAL CODE PHONE NUM HIRE DATE GUIDE NUM LAST NAME FIRST NAME ADDRESS 01010 617-555-6032 03/2012 Williamsburg MLA AMO1 Abrams Miles 54 Quest Ave. W1/2012 013-555-2134 Rita Jaffrey NH 140 Oakton Rd 01375 791-555-7767 1/82012 Sunderland Harley 25 Old Ranch Rd, DH01 NII 03388 603-555-8765 11/4/2012 Dummer 7 Alouse lleud kd G201 Gregory NH 643-535-1230 W8/2013 KS01 Kiley 943 Oaktoni Ra Joffrey Fraconist NH 03380 6/10/2013 61-353-0003 KSO2 Sam 9 Congaree Ave. MA 01101 91-2015 24 Shenandoah iad Springfield MRO1 Ray 044) Mount Desert ME 62/2014 12 Heather Rd. RIO 781-555-2323 207-555-9000 802-355-209 2003-555-8534 W5/2014 VT 05825 Lori 15 Riverton Rd, SL.01 ntry Glory 2/3/2015 342 Pinevicw St Danbury ESTO TRIP START LOCATION STATE SEASON NII VT VT ME ME llarts Location Weathersfield Vciathersfield Lewiston-Auburn North Newry Batchelders Grant Bloomfield Lincoln Tamworth Orange ME NII TRIP ID TRIP NAME 1) Arethusa Falls 2 Mt Ascutney - North Peak 3 Mt Ascutney - West Peak + Bradbury Mountain Ride 5 Baldpate Mountain Blucherry Mountain 7 Bloomfield - Midstone 8 Black Pond 9 Big Rock Cave 10 Mt. Cardigan - Fireseren 11 Chocorus Lake Tour 12 Cadillac Mountain Ride 13) Cadillas Mountain 14 Cannon Men 15 Crawford Path Presidentials like 16 Cherry Pond 17 Huguenot Head Hike 18 Low Bald Spot like 19 Mason's Farm 20 Lake Mephremagne Tour 21 Long Pond 22 Long Pond Tour 23 Lower Pond Tour 24 Bit Adams 25 Mount Battle Ride DISTANCE MAX GRP SIZE TYPE 5 10 Hiking 5 6 Hiking 0 10 Hiking 25 Biking 6 10 Hiking 8 8 Hiking 10 6 Paddling S 12 Hiking 6 10 liking 7 & Hiking 12 15 Puddling 8 16 Riking 7 SHiking 6 6 Hiking 16 + Hiking 6 16 Hiking 5 10 Hiking NII NII NH ME ME NII NII NII ME NII VT MA ME ME NII ME Bar Harbor Ber Harbor Frangonia Crawford Notch Whitefield Bar Harbor Pinkam Notch North Stratford Newport Rutland Greenville Poland Randall Camden Summer Late Spring Early Fall Early Fall Late Spring Early Fall Late Spring Summer Summer Summer Summer Early Fall Late Spring Early Fall Summer Spring Early Fall Early Fall Late Spring Late Spring Summer Summer Late Spring Summer Early Fall S S S 15 Puddling 12 liking 10 Paddling 15 Paddling 12 Bikini ENG ME ME NII TO Paddling Summer 15 | Prakalling Late Spring Summer Biking D 20 ME NII 6 15 NH NH MA MA Spring Early Fall Late Spring 22 Long Pond Tour 23 Lower Pand Tour 24 Mt Adams 25 Mount Battle Ride 26 Mount Cardigan Ilike 27) Mr. Chocorus 28 Mount Garfield Hike 29 Metanet Monadnock Trail Hike 30 Molannan Reservation Hike 31 Missisquoi River VT 32 Northern Forest Cance Trail 33] Park Loop Ride 34) Pontook Resensor Tour 35 Pisgah State Park Ride 16 Pondicherry Trail Radu 37 Seal Beach Harbor 38 Sawyer River Rede 39 Welch and Dickey Mountains Hike 40 Wachusete Mountain 41 Westfield liver Loop Greenville Poland Randolph Camden Cardigan Nihany Woodstock Pelham Tyringham Lowell Stark Mount Desert Island Tummer Northborough White Mountains Bar llarter Mount Carnain Thorton Princeton Fort Hairticla 12 Hiking 16 in 10 Puding 10 Paddling NII ME NII NII Summer Summler Late Spring Late Spring Summer Lato Spring Early Spring 1 20 Bikin NII ME NII le NII MN lolliking IS Biking 10 Hiking Hiking 10 Biking N Rarly Spring Late Spring ME The table named TRIP_GUIDES shown in Figure 1-8 is used to relate trips and guides. It includes the trip number and the guide number. The trip number in the TRIP GUIDES table matches a trip number in the TRIP table, and the guide number in the TRIP_GUIDES table matches a guide number in the GUIDE table. Figure 1-8. Table Used to Relate Trips and Guides TRIP_GUIDES TRIP GUIDES (CONTINUED) TRIPID GUIDE NUM TRIP_ID GUIDE_NUM 1 GZ01 1 RH01 2 AM01 2 SL01 3 SL01 4 BRO1 4GZ01 5 KS01 5 UGO1 6 RHO1 7 SL01 8 BROT 9 BROJ 10 GZ01 19 DH01 20 SL01 21 AM01 22 UG01 23 DH01 23 SL01 24 BR01 25 BR01 26 GZ01 27GZ01 DS BRO1 D DUOI 30 AMOL 31 SLOT 5 KS01 5 UGO1 6 RH01 7 SL01 8 BRO1 25 BRO1 26 | GZ01 27 GZ01 28 BR01 29 DH01 30 AM01 31 SLOT 9 BRO1 10 GZOT 1 DU01 11 KS01 11 UGO1 12 BRO1 13 RH01 14 KS02 15 GZ01 16 KS02 17 RHOD 18 KS02 32 KS01 33 UGO1 34 KS01 35 | GZ01 36 KSO2 37 RHO1 38 KS02 39 BRO1 40 DHO1 41 BRO1