1)Create a view, called vw_Customers, that shows all the customers (Full name in one column, Account Number, and Type of Account they have, and their current balance). Have the columns returned be called full_name, account_number, type_of_account, balance (Hint, you should use your Function created in question 3 to help with this).

2) Create a stored procedure called sp_all_customers that returns a select statement based on all columns of your view created in question 4 above.

3) Create a stored procedure, called sp_customer, that takes in a CustomerID as a parameter, and then returns a select statement that shows the full name of the customer, the full name of the employee that does the transaction, the name/code of the branch where the transaction was done, the transaction type (Deposit, or Withdrawal), and the amount of the transaction. The columns returned should be cust_full_name, emp_full_name, location, transaction_type, amount, customer_id

 

Transcribed Image Text:

Withdrawals Withdraw D Location D Employee Customer Withdraw Date Withdraw Amount WithdrawiSuccessfull Employees Employee EmployeeNumber FirstName LastName Title CanCreateNewAccount Hourly Salary Address City State ZipCode Email Address Locations Location D Location Code Address City State 00 Deposit Deposit Location D Employee D Customer DepositDate DepositAmount oo AccountType AccountType AccountType 00 CheckCashing CheckCashingD Location D Employee D Customer D CheckCashingDate CheckCashingAmount Customers Customer DateCreated Account Number AccountType FName LName Gender Address City State ZipCode EMailAddress Withdrawals Withdraw D Location D Employee Customer Withdraw Date Withdraw Amount WithdrawiSuccessfull Employees Employee EmployeeNumber FirstName LastName Title CanCreateNewAccount Hourly Salary Address City State ZipCode Email Address Locations Location D Location Code Address City State 00 Deposit Deposit Location D Employee D Customer DepositDate DepositAmount oo AccountType AccountType AccountType 00 CheckCashing CheckCashingD Location D Employee D Customer D CheckCashingDate CheckCashingAmount Customers Customer DateCreated Account Number AccountType FName LName Gender Address City State ZipCode EMailAddress

Answer rating: 100% (QA)

Step 11 1 CREATE VIEW CAMPOS AS SELECT CUSTOMERNAME BALANCE CREDITLIM... View the full answer