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