Question 9 (PL/SQL) - 35 marks a) Write a stored procedure that receives a given date as input and prints the details of the aireraft/plane scheduled for flights on that date and separately The following show the tables and sample data of La Trobe Airline. The PLANE prints those, which are not scheduled for a flight. and PILOT tables store the list of planes owned by the airline and the pilots working there respectively. PASSENGER table stores the information of the passenger flying with the airline. FLIGHT table stores information of the flights. This table includes information about the pilot and plane used. CITY table identifies the city where the airline flies to along with the airport information. PASSENGERFLIGHTS stores the relationship between passenger and flights. These are the ONLY tables in the airline database. NOTE: Primary Key (PK) is underlined, Foreign Key (FK) is printed in italic, PK that is also FK is underlined and printed in italic