Provide the implementation of the following stored procedures and function. For submission,

please include both the PL$/$SQL code and an execute procedure$/$SQL statement to demonstrate the

functionality.

a$.$ Create a stored procedure that takes a desired flight ID$,$ luggage limit$,$ class $($economy $\text{'}$E$\text{'},$

business $\text{'}$B$\text{'}$ or first class $\text{'}$F$\text{'})$ and desired number of seats as input, and outputs whether the

flight is available for booking or not. The procedure should make sure there are enough seats

available in the desired class; there is enough luggage room $($after subtracting mail cargo

capacity from the total cargo capacity$)$; and that the flight is estimated to depart at least $3$ hours

from the time that the stored procedure is executed.