CREATE OR REPLACE TRIGGER now_detained
AFTER INSERT
ON Sentence
FOR EACH ROW
WHEN (NEW.Conviction != 'Freed')
BEGIN
    UPDATE Serial_Killers
    SET STATUS = 'Detained'
    WHERE :NEW.Serial_Killer_ID = id;
END;
/


CREATE OR REPLACE TRIGGER now_free
AFTER INSERT
ON Sentence
FOR EACH ROW
WHEN (NEW.Conviction = 'Freed')
BEGIN
    UPDATE Serial_Killers
    SET STATUS = 'Free'
    WHERE :NEW.Serial_Killer_ID = id;
END;
/