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:
7 of 7
Paper No: 7
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
FUO
+ 81%
Close
