database Branch(branch-name, branch-city, assets) Customer(customer-name, customer-street, customer-city) Loan(loan-numb

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
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

Post by answerhappygod »

Database Branch Branch Name Branch City Assets Customer Customer Name Customer Street Customer City Loan Loan Numb 1
Database Branch Branch Name Branch City Assets Customer Customer Name Customer Street Customer City Loan Loan Numb 1 (703.67 KiB) Viewed 23 times
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)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply