create trigger Delete_sc on student for delete as delete student_course where student_course.s_no in(select s_no from deleted)