Delete The Accounts And Loans Of Downtown Branch #537

Online Quiz 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’;


Choose an organization

Theme Customizer

Gaussian Texture



Gradient Background