PK PK FLIGHT FLIGHT NUMBER FLIGHT NAME FLIGHT_PRICE FLIGHT_TO FLIGHT FROM FLIGHT_NUM_OF_SEATS DEPARTURE_DATE DEPARTURE_T

[answerhappygod]

Pk Pk Flight Flight Number Flight Name Flight Price Flight To Flight From Flight Num Of Seats Departure Date Departure T 1 (105.51 KiB) Viewed 42 times

REFER TO THE FIGURE ABOVE
1.) Determine and specify the functional dependencies that mayexist in your relations.
2.) Perform Normalization to relations with functionaldependencies.
3.) List all the derived final well-structured relations.
4.) Write the SQL query using the final well-structuredrelations to generate the information requirements in the QueryDescription Section.
PK PK FLIGHT FLIGHT NUMBER FLIGHT NAME FLIGHT_PRICE FLIGHT_TO FLIGHT FROM FLIGHT_NUM_OF_SEATS DEPARTURE_DATE DEPARTURE_TIME ARRIVAL_DATE ARRIVAL TIME Ican have DESTINATION DES ID DES NAME DES COUNTRY DES CITY search and book flight search and book flight PK FK PASSENGER PASS ID DES ID PASS_LNAME PASS_FNAME PASS_FROM PASS BOARDING_DATE PASS_BOARDING_TIME FIRST CLASS ENGER PK FCLASS PASS_ID FK DES_ID FCLASS PASS_LNAME FCLASS PASS_FNAME FCLASS FROM FCLASS BOARDING_DATE FCLASS BOARDING_TIME fill form access to H PK COUNTER CNTR NUMBER CNTR_NAME LOUNGE PK CNTR_NUMBER LOUNGE_NAME