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 3 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 3 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!