Need create

The following Figure shows a part of a relational database schema for an airline:

Table 1: Airport

Column

name

AirportCode Name city country

Datatype Number Varchar2 Varchar2 Varchar2

Length 6 255 255 255

Note PK

Table 2: Flight

Colu

mn

name

Flight_num

ber

Departure_A

irport Code

Arrival_Airpor

tCode

Departure_

time

Arrival_

time

Datat

ype

Varchar2 Varchar2 Varchar2 date date

Lengt

h

6 25 25

Note PK

Table 3: Customer

Column

name

CustomerID Name DoB country

Datatype Number Varchar2 date Varchar2

Length 6 255

255

Note PK

Table: Flight_reservation

Column

name

CustomerID Flight_number ResrvationDate

Datatype Number Varchar2 date

Length 6 25

Note PK

Create the airline database with above tables, then do the following queries:

1. A query that retrieves all airports in Gulf Cooperation Council (Saudi

Arabia, Qatar, United Arab Emirates, Oman, Kuwait, Bahrain).

2. A query that retrieves the number of all flights departing from King

Khalid International Airport (Code: RUH) on the same day of this HW.

3. A query that retrieves all airport names in capital letter.

4. Two different queries that retrieves all tables in Airline DB.

5. A query that retrieves all flights that are reserved during this week

6. A query that displays the current user of Airline DB.

7. A query that retrieves airport code and name in descending order by their

name

8. A query that retrieves the infant customers in flight number SV 608 (

infant : babies whose ages less than two years)

9. A query that retrieves the Canadian and American passengers arriving at

King Khalid International Airport (Code: RUH) tomorrow.

10. A query that retrieves all flights for YOU in last year.

11.