Needed your help.
I am working on an assignment in Oracle 11g
I have a table RESERVATION as shown below
The assignment is that :
Now Using a stored procedure and trigger(s), The system should be able to make a reservation. This includes adding a valid customer (and the number of seats needed) to a valid flight provided that the maximum number of passengers for the flight (the plane) has will not be exceeded. When a reservation is made, the total number of passengers on the flight must be updated. A reservation cannot be made on a flight in the past.
Can you please share the code which can be used here.