123 J 4 5 6 7 8 9 10 USE DB; DELIMITER $$ CREATE TRIGGER professor_delete BEFORE DELETE ON professor FOR EACH ROW BEGIN INSERT INTO professor_audit_trail ProfessorName = OLD. ProfessorName, ProgramName = OLD.Professor Program; END$$