delete from borrowers where branchcode = 'XXX';

delete from items where homebranch = 'XXX' and holdingbranch = 'XXX' and
itemnumber not in (select itemnumber from issues) and itemnumber not in (select
itemnumber from branchtransfers) and itemnumber not in (select itemnumber from
reserves);

delete from branches where branch code='XXX';