Answered step by step
Verified Expert Solution
Question
1 Approved Answer
/* flights Show all airports and the flights that originated there, if any. If the flight # field is null then replace that with the
/* 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 CODEStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started