COMPANY Company name AIRLINE_COMPANY Сompany_name AIRPLANE_COMPANY Company name AIRPORT Airport code Airport_name City State FLIGHT Flight number Company_name Weekdays FLIGHT_LEG Flight number Leg...


according to tables below, Create 5 views that are reasonable


COMPANY<br>Company name<br>AIRLINE_COMPANY<br>Сompany_name<br>AIRPLANE_COMPANY<br>Company name<br>AIRPORT<br>Airport code<br>Airport_name<br>City<br>State<br>FLIGHT<br>Flight number<br>Company_name<br>Weekdays<br>FLIGHT_LEG<br>Flight number<br>Leg number Departure_airport_code Arival_airport_code Scheduled_departure_time Scheduled_arrival_time<br>Mileage<br>LEG_INSTANCE<br>Elight_number<br>Leg number<br>Elight date<br>Departure_airport_code Arrival_airport_code<br>Number_of_available_seats<br>Airplane_ID Departure_time Arrival_time<br>FARE<br>Flight_number<br>Fare code<br>Amount<br>Restrictions<br>AIRPLANE<br>Airplane ID<br>Max_Seats Airplane type_name<br>Company_name<br>CAN LAND<br>Airplane ID<br>Airport code<br>

Extracted text: COMPANY Company name AIRLINE_COMPANY Сompany_name AIRPLANE_COMPANY Company name AIRPORT Airport code Airport_name City State FLIGHT Flight number Company_name Weekdays FLIGHT_LEG Flight number Leg number Departure_airport_code Arival_airport_code Scheduled_departure_time Scheduled_arrival_time Mileage LEG_INSTANCE Elight_number Leg number Elight date Departure_airport_code Arrival_airport_code Number_of_available_seats Airplane_ID Departure_time Arrival_time FARE Flight_number Fare code Amount Restrictions AIRPLANE Airplane ID Max_Seats Airplane type_name Company_name CAN LAND Airplane ID Airport code
CUSTOMER<br>Customer ID<br>Passport_number<br>Customer_name<br>e_mail<br>Customer phone<br>Adress<br>Country<br>FREQUENT_FLYER_CUSTOMER<br>Customer ID<br>Passport_number<br>Customer_name<br>e_mail<br>Customer_phone<br>Adress<br>Country<br>Frequent_flyer_number<br>TICKET<br>Ticket number<br>Flight_number<br>Leg_number<br>Flight date<br>Customer_ID<br>Fare_amount<br>Seat_number<br>Flying_class<br>CHECK_IN<br>Ticket number<br>Customer_ID<br>Check_configuraiton<br>TRANSACTION_RECORD<br>Ticket number<br>Flight number<br>Leg number<br>Customer ID<br>

Extracted text: CUSTOMER Customer ID Passport_number Customer_name e_mail Customer phone Adress Country FREQUENT_FLYER_CUSTOMER Customer ID Passport_number Customer_name e_mail Customer_phone Adress Country Frequent_flyer_number TICKET Ticket number Flight_number Leg_number Flight date Customer_ID Fare_amount Seat_number Flying_class CHECK_IN Ticket number Customer_ID Check_configuraiton TRANSACTION_RECORD Ticket number Flight number Leg number Customer ID

Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here