Week10 - Triggers / Assess

The questions can come in any order, so make sure you are selecting right option for all questions.

1. Create a trigger named 'trigger_travel_card_af_update' that is triggered whenever the travel_card table is updated. This trigger will insert the id,person_name and action into the table 'travel_card_log_history' after the updation of travel card details. The action name in the affected log table travel_card_log_history is 'After_Update_Travel_Card'. Hints: Trigger name : trigger_travel_card_af_update Table name : travel_card_log_history Field names : id,person_name,action Action : 'After_Update_Travel_Card'.

create or replace trigger trigger_travel_card_af_update
after update on travel_card
for each row
begin
insert into travel_card_log_history
values(:new.id,:new.person_name,'After_Update_Travel_Card');
end;
/

2. Create a trigger named 'trigger_travel_payment_delete' that is triggered whenever a record in the travel_payment table is deleted. This trigger will insert the id,travel_card_id, amount and action into the table 'travel_payment_log_history' after the deletion of travel_payment details. The action name in the affected log table travel_payment_log_history is 'After_Delete_Travel_Payment'. Hints: Trigger name : trigger_travel_payment_delete Table name : travel_payment_log_history Field names : id,travel_card_id,amount,action Action : 'After_Delete_Travel_Payment'.

create or replace trigger trigger_travel_payment_delete
after delete on travel_payment
for each row
begin
insert into travel_payment_log_history
values(:old.id,:old.travel_card_id,:old.amount,'After_Delete_Travel_Payment');
end;
/