Question 1 [4 Marks] With so much activity at airports, with planes flying in and out a huge amount of data can be collected daily. This result in big data that can be mined to reveal patterns and trends that can used to improve the services and operations of the airport. The data mining system is going to be able answer these following questions: - How many planes fly in and out of Namibia during a given period e.g. day, month, year etc. - How often are flights delayed or how often are they on time, how often do people fly to a specific country and how many of them in average? - How many passengers each plane carries in each time together with how many times is a flight fully booked. Using the description above, create a table named FLIGHT_INFO using six fields of your choice. Choose relevant data types and include one primary key. Question 2 [5 Marks] Write a statement to create a procedure which adds the passenger's age to the table created in Question 1. Create a statement to invoke the procedure, and a statement to verify that the record was successfully added. Question 3 [11 Marks] Write a statement to create a procedure which adds records to the FLIGHT_INFO table. The flight information should be added until it reaches a maximum of three. Make use of a loop. Make use of parameters to accept values. Write a statement to invoke the procedure. Question 4 [5 Marks] Write a statement to create a procedure which calculates and displays the average age of the passengers. Create a statement to invoke the procedure. Question 5 [13 Marks] Modify the procedure created in Question 4 to accept destination and total number of visits as input. The procedure must check if Germany was visited more than ten times, and then display the minimum age of the passengers. If Germany was visited less than ten times, display the maximum age of the passengers. Create a statement to invoke the procedure