3. Write a stored procedure with two parameters (account number and account date) to reset the LoanAmount and/or SavingAmount of the selected account. The resetting would be done on each of the suitable account (either loan or saving) as below:• Calculate the interest of the account (counted till the date when user runs this stored procedure)• Adding the interest into current account amount to have new account amount• Update the account information to the new account amount and the current date
đang được dịch, vui lòng đợi..