SQL script

BRANCH (BR_ Name, Asset, BR_City)

CUSTOMER ( CUST_Name, Street, Cust_City)

DEPOSIT (Acct_No , BR_Name, Cust_Name, Balance, TYPE) BORROW (Loan_NUM, BR_Name, Cust_Name, Amount)

1. Find out the loan numbers & names of all customers who borrow from the CARSON branch.

2. Find out the loan numbers, names of customers and the city they live who borrow from the

CARSON branch.

3. Find out who has borrowed over $100,000.

4. List all loan numbers & the branch name. Try to sort them in some ascending or descending

order.

5. List all customers who live in CARSON.

6. Find all customers of the CARSON branch. (Those have a loan, a deposit, or both). Answer the

query with more than one ways.

7. Find all customers of CARSON branch who have an account but not a loan. Answer the query

with more than one ways.

8. Find all customers of CARSON branch who have both an account & a loan. Answer the query

with more than one ways.

9. Find the assets & names of all branches which have depositors who live in Carson.

10. Find all customers who have a deposit account at ALL branches in Carson.