/* flights Show all airports and the flights that originated there, if any. If the flight # field is null then replace that with the word 'None" but leave flight date null.

Sort by airport code and flight #.

*/

FLIGHTS.FLIGHT FLIGHTS AIRLINE VARCHAR2 (6 BYTE VARCHAR2 (40 BYTE) P FLIGHT NO VARCHAR2 (10 BYTE) DATE P AIRLINE CODE FLIGHT DATE AIRLINE NAME F *FLIGHT_ORIGIN VARCHAR2 (5 BYTE) VARCHAR2 (5 BYTE) F FLIGHT_AIRLINE VARCHAR2 (6 BYTE) F AIRLINE COUNTRY VARCHAR2 (3 BYTE F FLIGHT DEST PK_AIRLINEID (AIRLINE CODE FKAIRLINECNTRY (AIRLINECOUNTRY PKAIRLINEID (AIRLINE-CODE PK_FLIGHTNO (FLIGHT NO) FK_AIRLINECODE (FLIGHT AIRLINE FK_DESTCODE (FLIGHTDEST FK ORIGCODE (FLIGHT ORIGIN) - - - ? ? PK-FLIGHTNO (FLIGHT-NO) FLIGHTS.COUNTRY P COUNTRY_CODE VARCHAR2 (3 BYTE) COUNTRY NAME VARCHAR2 (50 BYTE PKCOUNTRY!D (COUNTRYCODE? PK-COUNTRY!D (COUNTRY-CODE) - - FLIGHTS AIRPORT ? VARCHAR2 (5 BYTE VARCHAR2 (50 BYTE) VARCHAR2 (35 BYTE) VARCHAR2 (20 BYTE) VARCHAR2 (3 BYTE) P AIRPORT CODE AIRPORT NAME *AIRPORT CITY AIRPORT_STATE F AIRPORT COUNTRY PK_AIRPORTID (AIRPORT CODE) FKCOUNTRY AIRPORTCOUNTRY) - - ? PKAIRPORTID(AIRPORT CODE