Suppose there is a banking database which comprises following tables :
Customer(Cust_name, Cust_street, Cust_city)
Branch(Branch_name, Branch_city, Assets)
Account (Branch_name, Account_number, Balance)
Loan(Branch_name, Loan_number, Amount)
Depositor(Cust_name, Account_number)
Borrower(Cust_name, Loan_number)
1. Find all loans of over $1200
2. Find the names of all the customers who have taken a loan from the bank and also have an account at the bank.
3. Find the names of all customers who have a loan, an account, or both, from the bank..
4. Find the names of all customers who have a loan and an account at bank.
5. Find the names of all customers who have a loan at the Perryridge branch.
6. Find the names of all customers who have a loan at the Perryridge branch but do not have an account at any branch of the bank.
7. Find the names of all customers who have a loan at the Perryridge branch.
8. Find all customers who have an account from at least the “Downtown” and the Uptown” branches.
No comments:
Post a Comment