Write a Procedure (called add_new_client) to add new client, this procedure add also new account for this client, the acc_no column will start with 111 and increased by 1, the balance will be 0 for each new client. Add an exception s error message "client id is already used" if there is duplicated client id. Using (DUP_VAL_ON_INDEX). Write a deposit procedure that receive client id and amount to add this amount to clients balance and set the time of this transaction (as the last transaction time) Write a withdrawal procedure that receive client id and amount to deduct this amount to deduct this amount from this clients balance if his balance is covered otherwise show error message "sorry your balance is not enough", also set the time of this transaction (as last transaction time) Write a transfer procedure that have 3 parameters: clients' id for both sender and receiver also the amount to deduct this amount from the sender and add it to the receiver. Make sure that the sender balance is enough. Write a trigger to show old and new balance after each deposit, withdrawal or transfer transaction. Write a procedure called L_balance to display names and balances for all clients if the balance is less than entered amount (by user). Also show how many are they. Add an exception shows error message "no one is less than (entered amount). If there is no one found-Using (NO_DATA_FOUND), show the amount must be greater than 0, if the entered value is less than 0, finally show 'ERROR' for another exceptions. Write a display_info procedure to show all information of specific client. Write a Procedure (called add_new_client) to add new client, this procedure add also new account for this client, the acc_no column will start with 111 and increased by 1, the balance will be 0 for each new client. Add an exception s error message "client id is already used" if there is duplicated client id. Using (DUP_VAL_ON_INDEX). Write a deposit procedure that receive client id and amount to add this amount to clients balance and set the time of this transaction (as the last transaction time) Write a withdrawal procedure that receive client id and amount to deduct this amount to deduct this amount from this clients balance if his balance is covered otherwise show error message "sorry your balance is not enough", also set the time of this transaction (as last transaction time) Write a transfer procedure that have 3 parameters: clients' id for both sender and receiver also the amount to deduct this amount from the sender and add it to the receiver. Make sure that the sender balance is enough. Write a trigger to show old and new balance after each deposit, withdrawal or transfer transaction. Write a procedure called L_balance to display names and balances for all clients if the balance is less than entered amount (by user). Also show how many are they. Add an exception shows error message "no one is less than (entered amount). If there is no one found-Using (NO_DATA_FOUND), show the amount must be greater than 0, if the entered value is less than 0, finally show 'ERROR' for another exceptions. Write a display_info procedure to show all information of specific client
