For example, when we execute the procedure P1 with passenger_id = 1 by using the llowing statements, the result should be as in the following figure:
6 of 6
Paper No: 10
declare @x int
exec P1 1, @x output
select @x as NumberOfBookings
NumberOfBookings
1
1
Picture 8.1
Question 9:
Create a trigger named T1 for the delete statement on the "booking" table so that when we call a delete statement to delete one or more rows from the "booking" table, the system will automatically delete also from the "baggage" table all the baggage of the deleted bookings.
For example, if we call the following statement to delete 2 bookings with id = 10 and id = 11 from the "booking table, all the rows with booking_id = 10 and booking_id = 11 must also be deleted from the "baggage" table.
Zoom
+ 82%
Close
