Any suggestions how to achieve the below requirement
Create table Company_Account (Account_Id number, Account_Name varchar2(200),Amount number);
Create table Employee_Account (EID number,ename varchar2(100),Account_bal number,his_monthly_Sal number);
Monthly each and every employee will be receiving salary based on the “his_monthly_Sal” column of “Employee_Account” table and this salary value will be added to “Account_bal” column in “Employee_Account”. At the same time whatever the amount is being added to every employee should be deducted from the “Amount” column of the “Company_Account” table.