Please tell me the answer quickly. Use MySQLworkbench thanks. Please tell me the
ID: 3907168 • Letter: P
Question
Please tell me the answer quickly.Use MySQLworkbench thanks. Please tell me the answer quickly.
Use MySQLworkbench thanks. Use MySQLworkbench thanks. ITS62904- Database Systems swer Question 1 (0) and (ii) based on Figure 1, and 2 Hr schema (Employee table) note: Salary is monthly salary Employee_id - Primary Key Figure 1: Employees table (i) Write SQL statement to create a new table called Salary Processing with the columns mentioned in Figure 2. Employee id and salary information should be extracted from employee's schema given in the Figure 1 . The rest of the oolmns should be set default = 0. Test: Emp raise table will have the in Figure 2 Figure 2: Columns required as output and example of tabulated outpu ()Write a single procedure to complete the following operations 1, Calculate the increase of the employee's monthly salary by 15%. 2, calculate the reduction of the employee's monthly salary by 15%. 3. Calculate the Projection of salary for the next 10 years using the outcome of column increment 15%. (" monthly salary only increase once) 4. Calculate the Projection of salary for the next 10 years using the outcome of column reduce-5%. (. monthly salary only increase once) Submission File Name: Student Name Student id Word File-with screenshot of outcome
Explanation / Answer
Dear Sir/Madam,
Please find the folowing sql queries regarding your question.
Creating Table :
create table Salary_Processing(Employee_Id int, Salary real,
increment_15 real,reduce_5 real,projection_increased_15 real,
prjectin_reduced_5 real);
Insering Records:
insert into Salary_Processing
values(1,10,0,0,0,0);
Displayng Output :
select *from Salary_Processing;
EMPLOYEE_ID SALARY INCREMENT_15 REDUCE_5 PROJECTION_INCREASED_15 PRJECTIN_REDUCED_5
----------- ---------- ------------ ---------- ----------------------- ------------------
1 10 0 0 0 0
Creating Procedure :
Create or replace procedure Salary_Processing_Output(Emp_id IN number)
Is
BEGIN
update Salary_Processing set increment_15 = Salary*1.15 where Employee_id=@Emp_id;
update Salary_Processing set reduce_5 = Salary*0.95 where Employee_id=@Emp_id;
update Salary_Processing set Projection_increased_15 = (Salary*1.15)*10 where Employee_id=@Emp_id;
update Salary_Processing set PRJECTIN_REDUCED_5 = (Salary*0.95)*10 where Employee_id=@Emp_id;
select *from Salary_Processing ;
END;
Executing the Procedure :
EXEC Salary_Processing_Output(1);
Output :
EMPLOYEE_ID SALARY INCREMENT_15 REDUCE_5 PROJECTION_INCREASED_15 PRJECTIN_REDUCED_5
----------- ---------- ------------ ---------- ----------------------- ------------------
1 10 11.5 9.5 115 95
If you are facing any issues just ping me at yoganjula.g@hotmail.com
Thank you and all the best:)
With Regards,
Yoganjula Reddy G.