PK PK FLIGHT FLIGHT NUMBER FLIGHT NAME FLIGHT_PRICE FLIGHT_TO FLIGHT FROM FLIGHT_NUM_OF_SEATS DEPARTURE_DATE DEPARTURE_T
Posted: Sun Jul 10, 2022 11:23 am
- 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 43 times
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