you can use Trigger
create trigger [dbo].[tri_Name] on tbl_Ag_Master
for delete
as
declare @Given_Id bigint;
declare @Assignment_Id bigint
select @Assignment_Id=d.Assignment_Id from deleted d;
select @Given_Id =d.Given_Id from deleted d;
delete from tbl_Ag_Child where Given_id=@Given_Id
delete from tbl_Bach_Ag where Assignment_Id_id=@Assignment_Id