Question: Consider the following relation named Trip. Trip ( TriplD , TripName, StartLocation, State, Distance, ( Max GipSize, Type, SeasonNum, Season The functional dependencies are as

Consider the following relation named Trip.
Trip
(TriplD, TripName, StartLocation, State, Distance,
(Max GipSize, Type, SeasonNum, Season
The functional dependencies are as follows:
TriplD, SeasonNun
TriplD
JTripName, StartLocation, State,
Distance, MaxGrpSize, Type, Season)
J Trip Name, StartLocation, State,
Distance, MaxGrpSize, Type
SeasonNm > Season
The tables that are in third normal form are:
OC.
Trip( TripllD, TipName, StartLocation, State, Distance, Max GrpSize, Type)
Season(TriplD, SeasonNun, Season)
None of the above
A
B.
Trip(TriplD, TipName, StartL.ocation, State, Distance, MaxGrpSize, Type)
Season (ScasonNum_eason)
Trip( TriplD, TripNane, StartLocation, State, Distance, MaxGrpSize, Type)
Season (SeasonNun. Season). TripSeason(TiplD, SeasonNun )

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!