Question: b . You may find it easier to complete Question ( a ) before this question. Create a stored procedure that takes a desired arrival
b You may find it easier to complete Question a before this question. Create a stored procedure that takes a desired arrival airport code, departure airport code, luggage limit class economy E business B or first class F and desired number of seats as input and prints out the flight number NE followed by the last digits of the flight ID of all flights that are available for booking that will travel between the specified airports. As in Question a the procedure should check whether there are enough seats available in the desired class, whether there is enough luggage room after subtracting mail cargo capacity from the total cargo capacity and whether each flight is estimated to depart at least hours from the time that the stored procedure is executed. Hint: It may help to use the SUBSTR function.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
