USE lab09;

#Step 1: Delete the professor with id 2
DELETE FROM professor
	WHERE ProfessorID=2;

#Step 2: Display the professor_audit_trail table to show that the trigger works, save a screenshot
SELECT * FROM lab09.professor_audit_trail;

#Step 3: Delete the index, view, and trigger created in other files
DROP INDEX ixStudentProgram ON student;
DROP VIEW CompSciStudents;
DROP TRIGGER DeletedProfTrigger;