1- What are the primary key fields for the TRIP_GUIDES table? 2- Does the TRIP_G
ID: 3882836 • Letter: 1
Question
1- What are the primary key fields for the TRIP_GUIDES table?
2- Does the TRIP_GUIDES table have a Composite Key? (Yes or No) Why or why not?
3- What are the primary key field(s) in the TRIP table?
4- Does the TRIP table have a Composite Key? (Yes or No) Why or why not?
TRIPID TRIP_NAME STARTLOCATION- STATE DISTANCE MAXGRPSIZE 1 SEASON Click to Add - - - - 1 Arethusa Falls 10 Hiking Summer Harts Locationn Weathersfield Weathersfield Lewiston-Auburn North Newry Batchelders Grant Bloomfield Lincoln Tamworth Orange Tamworth 2 Mt Ascutney - North Peak Late Spring Hiking 10 Hiking 3 Mt Ascutney - West Peak 4 Bradbury Mountain Ride 5 Baldpate Mountain 10 Hiking Late Spring 8 Hiking 6 Paddling Late Spring 6 Blueberry Mountain ME 7 Bloomfield - Maidstone 8 Black Pond 12 Hiking Summer 10 Hiking Summer 8 Hiking Summer 15 Paddling Summer 9 Big Rock Cave 10 Mt. Cardigan - Firescrew 11 Chocorua Lake Tour 12 Cadillac Mountain Ride 13 Cadillac Mountain 14 Cannon Mtn 15 Crawford Path Presidentials Hike 16 Cherry Pond 17 Huguenot Head Hike 18 Low Bald Spot Hike 19 Mason's Farm 20 Lake Mephremagog Tour 21 Long Pond 22 Long Pond Tour 23 Lower Pond Tour 24 Mt Adams 25 Mount Battie Ride 26 Mount Cardigan Hike 27 Mt. Chocorua 28 Mount Garfield Hike 29 Metacomet-Monadnock Trail Hike 30 McLennan Reservation Hike 31 Missisquoi River VT 32 Northern Forest Canoe Trail 33 Park Loop Ride 34 Pontook Reservoir Tour 35 Pisgah State Park Ride 36 Pondicherry Trail Ride 37 Seal Beach Harbor 38 Sawyer River Ride 39 Welch and Dickey Mountains Hike 40 Wachusett Mountain 12 8 Hiking Late Spring Franconia Crawford Notch Whitefield 6 Hiking 4 Hiking 16 Hiking 10 Hiking Summer Spring 6 Hiking 7 Paddling Late Spring 15 Paddling Late Spring 12 Hiking Summer 10 Paddling Summer 15 Paddling Late Spring 6 Hiking Summer Pinkam Notch North Stratford 12 Rutland Greenville Poland 12 16 Hiking Late Fall 10 Hiking Spring 10 Hiking Early Fall 12 Hiking Late Spring 16 Hiking Summer 10 Paddling Summer 10 Paddling Summer 8 Biking Late Spring 14 Paddling Late Spring 10 Biking Summer 4 Albany Woodstock Pelham Ivringham 12 15 Stark Mount Desert Island MBE Dummer Northborough White Mountains 15 12 15 Late Spring Early Spring 16 Hiking Mount Carrigain Thorton Princeton 10 Hiking Summer 8 Hiking Early SpringExplanation / Answer
1- What are the primary key fields for the TRIP_GUIDES table?
primary key fields are TRIP_ID ,and TRIP_NAMES. These two fields uniquely identifiy the row in TRIP_GUIDES table
2- Does the TRIP_GUIDES table have a Composite Key? (Yes or No) Why or why not?
Yes. keys(TRIP_ID,START_LOCATION), or (TRIP_NAMES , START_LOCATION) uniquely identifiy the rows.
3- What are the primary key field(s) in the TRIP table?
primary key fields are TRIP_ID and GUIDE_NUM, as they uniquely identifiy the rows.
4- Does the TRIP table have a Composite Key? (Yes or No) Why or why not?
No. because they have only two fields which are already a primary key.
composite keys are key that consists of more than one attribute to uniquely identify rows.
//for more clarification please do comments
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.