Answered step by step
Verified Expert Solution
Question
1 Approved Answer
MySQL - (c) Create a list of direct flights (including scheduled departure time and arrival time) starting from Baltimore Washington International Airport (Airport_code is 'BWI')
MySQL - (c) Create a list of direct flights (including scheduled departure time and arrival time) starting from Baltimore Washington International Airport (Airport_code is 'BWI') and terminating at San Francisco International Airport (Airport_code is 'SFO') which have more than two seats available on 8/15/2018. In addition, create a list of direct returning flights from 'SFO' to 'BWI' on 8/22/2018.
AIRPORT FLIGHT LEG Leg_no INT City VARCHAR(45) State VARCHAR(45) Scheduled_arr_time TIME Scheduled_dep_tme TIME FLIGHT Num ber INT Airline VARCHAR(45) Name VARCHAR(45) AIRPORT-Airport Code VARGAR (45) Weekdays VARCHAR(45) FLIGHT Number INT FARE Code INT Amount DECIMAL(7,2) LEG_INSTANCE CAN_LAND AIRPORT_Airport_code VARCHAR (45) AIRPLANE TYPE Type name VARCHAR(45) Noofavail seats INT - - Date DATE FLIGHT_LEG Leg_no INT AIRPLANE_Airplane id INT Arr-time TIME Dep time TIME AIRPORT, Airport_code VARAR(45) Restrictions VARCHAR(45) FLIGHT Number INT AIRPLANETYPE - Company VARCHAR(45) ?Type_name VARCHAR(45) Max_seats INT SEAT Seat no INT Custom er_name VARCHAR(45) Cphone BIGINT(10) LEG_INSTANCE Date DATE AIRPLANE Airplane_id INT Total_no of_seats INT AIRPLANE, TYPE Typename VARCHAR(45)Step 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