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.
delete from booking where id in (10,11)
Question 10:
Write statements to insert into the "flight" table a new flight with id = 400 of the airline named 'Vietnam Airlines'; this flight departs at 23:15:00 on 17 March 2024 from the airport with the code 'HAN' and arrives at 06:30:00 on 18 March 2024 at the airport with the code 'CDG'.The departing_gate and the arriving_gate of the new flight must be NULL.
Zoom
+ 113%
Close
