1. Delete the accounts and loans of Downtown branch. AnswerAnswer: 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’; 2. Add a column phoneNo to customer table. AnswerAnswer: alter table…