database Branch(branch-name, branch-city, assets) Customer(customer-name, customer-street, customer-city) Loan(loan-numb
Posted: Wed Mar 30, 2022 9:29 am
- Database Branch Branch Name Branch City Assets Customer Customer Name Customer Street Customer City Loan Loan Numb 1 (703.67 KiB) Viewed 25 times
at least one account at that branch.
Find the names and account number of customers who have the
3 highest balances in their accounts.
If the bank gives out 5% interest to all accounts, show the
branch name and total interest across each branch.
database Branch(branch-name, branch-city, assets) Customer(customer-name, customer-street, customer-city) Loan(loan-number, branch-name, amount) Borrow(customer-name, loan-number) Account(account-number, branch-name, balance) Depositor(customer-name, account-number)