Added trigger when to the bookings relation. Wrote procedures to give all passengers a ticket number and implented them using cursors.