Answer Happy

1. Consider the bank database with the relational schema below to write the SQL commands for each of the following queries: branch (branch name, branch city, assets) customer (ID, customer_name, customer_street, customer_city) -loan (loan_number, branch name, amount) barrower(ID. loan number) account (account number, branch name, balance) depositor (ID, account number, d date) JOIN a) Find the name of each branch located in "Makurdi". b) Find the ID of each borrower who has a loan in "Suleja" ✓e) Find all the account numbers that received a deposit in Makurdi branch on 20th June, 2022. d) Find the name of all customers who have taken a loan and the loan amount they have taken. ✔e) Write the Data Definition Language (DDL) Command to create the "loan" table. D) Write the SQL command to update all account balances by 1%. 8) Write the SQL command to insert a new customer's record. (Use your own specific ID, name, and any other dummy value as necessary to answer this question correctly). h) Write the equivalent Relational Algebra Expression for Question la.. Write the equivalent Relational Algebra Expression for lb. ) Write the equivalent Relational Algebra Expression for Question le. k) Is the ER-diagram below violating any of the rules of normalization? Justify your answer by explaining how there is no violation or identify the rule it violating and how can it can be resolved. 0.01 ACCOUNT #account_number "balance "date_opened bank location Pas 1 1 BANK #bank_number "name