Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write SQL statement to do the following: a) Using one statement insert the data of at least three customers into the SEAT_RESERVATION table. b) Increase

image text in transcribed

Write SQL statement to do the following: a) Using one statement insert the data of at least three customers into the SEAT_RESERVATION table.

b) Increase the AMOUNT of all FARES for passengers who fly KLM the 5%.

c) List the passengers onboard LT_575 whose destination is Kotoka International Airport.

d) Remove the record of the Airplane with the identification number BA_6789.

e) Report on all the passengers who booked a flight in the system

f) Display all the AIRPLANE _TYPES possessed by British Airways

g) Show the price list of all International Airlines

h) Give a discount of 10% on all fares to passengers who travel on British Airways.

i) Report on the flight leg for Airlines whose name is prefixed with K

j) Retrieve the sum, count and maximum of the available seats on the all airplanes that are due for departure between the hours of 9:00 am and 12:00 noon.

AIRPORT Airport_code Name City State FLIGHT Flight number Airline Weekdays FLIGHT_LEG Flight_number Leg_number Departure_airport_code Arrival airport code Scheduled departure_time Scheduled arrival time LEG_INSTANCE Flight number Leg number Date Number_of_available_seats Airplane_id Departure airport code Departure_time Arrival_airport code Arrival time FARE Flight_number Fare_code Amount Restrictions AIRPLANE_TYPE Airplano_type_name Max_seats Company CAN_LAND Airplane_type name Airport_code AIRPLANE Airplane_id Total_number_of_seats Airplane_type SEAT RESERVATION Flight_number Leg_number Date Seat_number Customer name Customer_phone

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

More Books

Students also viewed these Databases questions

Question

When is it appropriate to use a root cause analysis

Answered: 1 week ago