21.35:09 PMⒸ:ll 24 58K/SDoneĈ28xAirline CompanyAn airline company is interested in implementing a database system to manipulate theflights that it organizes.The airline company has a certain number of airplanes. Each airplane has a unique code,a number of seats and a production year. An airplane belongs to a certain airplanemodel. Each model has a unique model number and is provided by a certain company.We have different airplanes of each model. Each flight is identified by a flight number, ascheduled departure time and a scheduled arrival time. We want also to keep track ofthe airport from which the flight is scheduled as well as the destination airport. Eachairport is identified by a unique code, its name and the country in which it is located.Journeys of each flight are organized on a daily basis. Each journey is identified by adate, its actual departure time, its actual arrival time, and the number of passengers, inaddition to the airplane that performs the journey. We want to keep track of the seatsoccupied, where each seat is identified by a seat number, a passenger name, nationality,age and phone number.Steps to be doneStep 1: Data Modeling - Create an ER diagram,Step 2: Map ER diagram into a relational model,Step 3: Create your tables and fill them with few records of logical data,Step 4: SQL QueriesSQL Queries1- List the total number of journeys done during October 2015.2- List theany name of all available airplanes.3- List the total number of airports in each country.4- List flight number, departing airport name, arrival airport name, scheduled departuretime, scheduled arrival time of all the flights that has 'France' as their destinationcountry.5- List the total number of passengers that traveled on '25-09-2015'.6- List the total number of passengers from each nationality that travelled on thejourney date between '11-10-2015' and '16-10-2015' of the flight number '227"7- List journey date, flight number, departing airport name, arrival airport name, actualdeparture time, actual arrival time of all the journeys that departed or landed at'Beirut International Airport'.8- List airplane code, number of seats, production year and airplane companyairplanes produced after the year 2010.9- List the average age of passengers who traveled to 'Lebanon' in '2015'.10-List flight number, journey date, departing airport, actual departure time, arrivalairport, actual arrival time of all flights that are done on airbus airplanes (companyname = 'airbus') on "19-11-2015'Write 5 additional queries that you find useful for this application. Thequeries should not be easy.□◇Wrap Textا...A+ A B

Question

21.35:09 PMⒸ:ll 24 58K/SDoneĈ28xAirline CompanyAn airline company is interested in implementing a database system to manipulate theflights that it organizes.The airline company has a certain number of airplanes. Each airplane has a unique code,a number of seats and a production year. An airplane belongs to a certain airplanemodel. Each model has a unique model number and is provided by a certain company.We have different airplanes of each model. Each flight is identified by a flight number, ascheduled departure time and a scheduled arrival time. We want also to keep track ofthe airport from which the flight is scheduled as well as the destination airport. Eachairport is identified by a unique code, its name and the country in which it is located.Journeys of each flight are organized on a daily basis. Each journey is identified by adate, its actual departure time, its actual arrival time, and the number of passengers, inaddition to the airplane that performs the journey. We want to keep track of the seatsoccupied, where each seat is identified by a seat number, a passenger name, nationality,age and phone number.Steps to be doneStep 1: Data Modeling - Create an ER diagram,Step 2: Map ER diagram into a relational model,Step 3: Create your tables and fill them with few records of logical data,Step 4: SQL QueriesSQL Queries1- List the total number of journeys done during October 2015.2- List theany name of all available airplanes.3- List the total number of airports in each country.4- List flight number, departing airport name, arrival airport name, scheduled departuretime, scheduled arrival time of all the flights that has 'France' as their destinationcountry.5- List the total number of passengers that traveled on '25-09-2015'.6- List the total number of passengers from each nationality that travelled on thejourney date between '11-10-2015' and '16-10-2015' of the flight number '227&#34;7- List journey date, flight number, departing airport name, arrival airport name, actualdeparture time, actual arrival time of all the journeys that departed or landed at'Beirut International Airport'.8- List airplane code, number of seats, production year and airplane companyairplanes produced after the year 2010.9- List the average age of passengers who traveled to 'Lebanon' in '2015'.10-List flight number, journey date, departing airport, actual departure time, arrivalairport, actual arrival time of all flights that are done on airbus airplanes (companyname = 'airbus') on &#34;19-11-2015'Write 5 additional queries that you find useful for this application. Thequeries should not be easy.□◇Wrap Textا...A+ A B

Accepted Answer

ERD:
Unique id: Airline_id, Model_id, Flight_number, Airport_id, date, seat_no
Dept_time: Departure…