Find the names of each branch and the number of customers having
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)
database Branch(branch-name, branch-city, assets) Customer(customer-name, customer-street, customer-city) Loan(loan-numb
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
database Branch(branch-name, branch-city, assets) Customer(customer-name, customer-street, customer-city) Loan(loan-numb
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!