Identify the functional dependencies in the following unnormalized table. Convert the table to third normal form. Is the result also in fourth normal form? Why or why not?

Details

The unnormalized Trip table in which the functional dependecies have to be determined. The table is to be converted to third normal form. Trip left parenthesis Trip I D$,$ Trip Name, State Abbreviation, State Name, left parenthesis Guide N u m$,$ Guide Last, Guide First right parenthesis right parenthesis. Trip I D is the primary key.