Test Instructions: 1. Use SQL to create the tables listed below. (15 Points) FLIGHT PK FlightID...

  

Transcribed Image Text:

Test Instructions: 1. Use SQL to create the tables listed below. (15 Points) FLIGHT PK FlightID AirlineName FlightNumber DepartureDateTime FK DestinationID AirplaneType DestinationID 5698 7558 8569 6654 NUMBER(6) VARCHAR(15) NUMBER(4) TIMESTAMP NUMBER(4) VARCHAR(4) 2. Use SQL to insert the data listed below into each table. (15 Points) FlightID AirlineName 369987 United 236774 112558 223698 857457 Chicago Denver Delta Delta Jet Blue Southwest DESTINATION PK DestinationID DestinationCity DestinationState Destination City Destination State DestinationAirportCode Philadelphia PHI San Francisco SFO ORD DEN NUMBER(4) VARCHAR(25) VARCHAR(2) Destination AirportCode VARCHAR(3) PA CA IL CO Valid Airplane Types: A350, 737, 747, 767 FlightNumber 1200 1645 1842 9965 1269 3. Using SQL, update the Flight Number for FlightID 857457 to 1260. (10 points) 4. Using SQL, create a query that displays the Airline Name, Flight Number and Airplane Type for all non-A350 flights. (10 points) DepartureDateTime DestinationID AirplaneType 11/15/2023 10:00 AM 7558 737 11/15/2023 04:30 PM 6654 11/16/2023 08:15 PM 11/16/2023 09:20 AM 11/17/2023 07:45 PM 5698 5698 7558 A350 767 767 747 5. Using SQL, create a query that displays the Airline Name, Flight Number, Departure Date/Time and Airport Code for all flights traveling to San Francisco ordered by Airline Name. (10 points) 6. Using SQL, create a query that displays every City and State and identify the Airline Name, Flight Number and Departure Date/Time for each flight ordered by City then by Airline Name. (10 points) 7. Upload your SQL file on Blackboard under Assignments Exams Exam 2 Exam 2 - SQL Programming Submission by 9:40pm. Test Instructions: 1. Use SQL to create the tables listed below. (15 Points) FLIGHT PK FlightID AirlineName FlightNumber DepartureDateTime FK DestinationID AirplaneType DestinationID 5698 7558 8569 6654 NUMBER(6) VARCHAR(15) NUMBER(4) TIMESTAMP NUMBER(4) VARCHAR(4) 2. Use SQL to insert the data listed below into each table. (15 Points) FlightID AirlineName 369987 United 236774 112558 223698 857457 Chicago Denver Delta Delta Jet Blue Southwest DESTINATION PK DestinationID DestinationCity DestinationState Destination City Destination State DestinationAirportCode Philadelphia PHI San Francisco SFO ORD DEN NUMBER(4) VARCHAR(25) VARCHAR(2) Destination AirportCode VARCHAR(3) PA CA IL CO Valid Airplane Types: A350, 737, 747, 767 FlightNumber 1200 1645 1842 9965 1269 3. Using SQL, update the Flight Number for FlightID 857457 to 1260. (10 points) 4. Using SQL, create a query that displays the Airline Name, Flight Number and Airplane Type for all non-A350 flights. (10 points) DepartureDateTime DestinationID AirplaneType 11/15/2023 10:00 AM 7558 737 11/15/2023 04:30 PM 6654 11/16/2023 08:15 PM 11/16/2023 09:20 AM 11/17/2023 07:45 PM 5698 5698 7558 A350 767 767 747 5. Using SQL, create a query that displays the Airline Name, Flight Number, Departure Date/Time and Airport Code for all flights traveling to San Francisco ordered by Airline Name. (10 points) 6. Using SQL, create a query that displays every City and State and identify the Airline Name, Flight Number and Departure Date/Time for each flight ordered by City then by Airline Name. (10 points) 7. Upload your SQL file on Blackboard under Assignments Exams Exam 2 Exam 2 - SQL Programming Submission by 9:40pm.