Question: Given the following Trip table, list all the functional dependencies in the table. The same tripID could have multiple guides serve it (TripID is the

Given the following Trip table, list all the functional dependencies in the table. The same tripID could have multiple guides serve it (TripID is the primary key). Convert the table to third normal 2. rm. Trip (TripID, TripName, StateAbbreviation, StateName, (Guide ID, GuideLast, GuideFirst)) Example GuideLast GuideFirst Abrams Bovers Rowan Abrams Devon TripID TripName StateAbbr StateName GuidelD California AM01 BR01 RH01 AM01 DH01 Miles Rita Hal Miles Harle Arethusa Fall CA Mt Ascutney VT Vermont
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
