Delete The Accounts And Loans Of Downtown Branch #537
This subjective question is related to the book/course gs gs114 Relational Database Management System. It can also be found in gs gs114 Practical Questions Solved Past Paper No. 1.
Question 1: Delete the accounts and loans of Downtown branch.
Answer:
delete from depositor where account_number IN (select account_number from account where branch_name=’Downtown’); delete from account where branch_name=’Downtown’;
delete from borrower where loan_number IN
(select loan_number from loan where branch_name=’Downtown’);
delete from loan where branch_name=’Downtown’;