Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
QUESTION
(Using a procedure) System should be able to add new customers ensuring that no duplicates are entered, and type is valid. A message should be...
- (Using a procedure) System should be able to add new customers ensuring that no duplicates are entered, and type is valid. A message should be returned with the success or failure of the action.
- (Using a procedure) System should be able to add a new account for an existing customer. Given a customer ID, and an account type, the system should verify that the customer id, and account type are valid, then create a new account. A message should be returned with the success or failure of the action.
- (Using a procedure and trigger) System should be able to handle valid transactions on valid accounts for valid customers maintaining the integrity of the account balances. Specifically, the system should allow deposits to accounts (must have account number, amount), withdrawals (must have account number, amount) from accounts and transfers between accounts (must have 2 account numbers and an amount). When these transactions are made, the account balance must be updated (via trigger). No account balance may go below zero. A message should be returned with the success or failure of the action.
- Using a procedure) Given an amount, display the account number, last name, and amount of all transactions with an amount greater than the one passed into the procedure.
- [EXTRA CREDIT]: Write a trigger so that anytime a customer changes their address, the old address, new address, date, customer id and user ID are stored in a log.
