Problem
1. Make a list of security concerns for a bank. For each item on your list, state whether this concern relates to physical security, human security, operating system security, or database security.
2. Using the relations of our sample bank database, write an SQL expression to define the following views:
a. A view containing the account numbers and customer names (but not the balances) for all accounts at the Deer Park branch.
b. A view containing the names and addresses of all customers who have an account with the bank, but do not have a loan.
c. A view containing the name and average account balance of every customer of the Rock Ridge branch.