1. The functional dependencies in the following relation are given below, | 2pm Flight 1001 1001 1001 1001 1001 | 1001 | 1031 1031 | 1031 Origin MCO MCO MCO MCO MCO MCO JAX JAX JAX Dest. Departure Arrival Duration Cap. JAX 10am 11am 1hr 80 JAX 10am 11am 1hr 80 JAX 10am 11am 1hr 80 JAX 1pm 1hr 80 JAX | 1pm 2pm 1hr 80 JAX 1pm 2pm 1hr 80 SAN | 2pm 8pm 8hr 80 SAN 2pm 8pm 8hr 80 (SAN 2pm 8pm 8hr 80 Cabin Price Coach 200 Business 400 First 600 Coach 200 Business 400 First 600 Coach 350 Business 550 First 700 Flight Origin, Dest., Duration, Cap. (Partial Dependency) Flight, Cabin Origin, Dest., Duration, Cap., Price (Partial Dependency) Flight, Departure Origin, Dest., Arrival, Duration, Cap. (Partial Dependency) Flight, Departure, Cabin Origin, Dest., Arrival, Duration, Cap., Price Is the relation in Problem 1 in 1NF, 2NF, 3NF? If not, explain why and transform the relation into 1NF, 2NF, and then 3NF. 1. The functional dependencies in the following relation are given below, | 2pm Flight 1001 1001 1001 1001 1001 | 1001 | 1031 1031 | 1031 Origin MCO MCO MCO MCO MCO MCO JAX JAX JAX Dest. Departure Arrival Duration Cap. JAX 10am 11am 1hr 80 JAX 10am 11am 1hr 80 JAX 10am 11am 1hr 80 JAX 1pm 1hr 80 JAX | 1pm 2pm 1hr 80 JAX 1pm 2pm 1hr 80 SAN | 2pm 8pm 8hr 80 SAN 2pm 8pm 8hr 80 (SAN 2pm 8pm 8hr 80 Cabin Price Coach 200 Business 400 First 600 Coach 200 Business 400 First 600 Coach 350 Business 550 First 700 Flight Origin, Dest., Duration, Cap. (Partial Dependency) Flight, Cabin Origin, Dest., Duration, Cap., Price (Partial Dependency) Flight, Departure Origin, Dest., Arrival, Duration, Cap. (Partial Dependency) Flight, Departure, Cabin Origin, Dest., Arrival, Duration, Cap., Price Is the relation in Problem 1 in 1NF, 2NF, 3NF? If not, explain why and transform the relation into 1NF, 2NF, and then 3NF