Please answer the two questions below

5) Consider the following relation AIRLINE TABLE Flight Flight Origin Destination Captain Captain Number of Date ID ID Name Passengers on the Flight April 10 111 Chicago L.A. 111 Tracy 1 10 April 10 222 L.A. Phoenix 222 Matt 105 April 12 111 Chicago L.A 444 Tim 98 April 12 333 L.A. N.Y. 111 Tracy 75 April 12 144 L.A. N.Y. 333 Pat 110 April 12 555 L.A Dallas 444 Tim 111 April 12 222 L.A. Phoenix 555 Pat 107 Some of the requirements that this table is based on are as follows: a) The AIRLINE is flying number of flights on various routes daily. A flight with a particular Flight Id always flies on the same route (same Origin and same Destination). Every captain has a unique Captain Id, and a non-unique Captain Name. d) For each instance of a flight (a particular flight on a particular Flight Date) we keep track of who was the captain of that instance of a flight and how many passengers were on board (Number of Passengers on the Flight). e) A captain can fly multiple flights during the same day. Normalize the relation to the second normal form (2NF). 5 points Normalize the relation to the third normal form (3NF). 5 points