Question: write PL/SQL query with output in oracle Chris owns auto repair business wants to calculate the weekly salary of employees Based on the following criteria
Chris owns auto repair business wants to calculate the weekly salary of employees Based on the following criteria 1. If an employee works over 40 hours in a week, Chris pays that employee 1.5 times his or her regular hourly pay rate for all hours over 40. (.e. for 65 hours = 40 hours normal rate + 25 hours overtime pay. (assume that Hourly rate is 14.00) 2. If it is less than 40 hours (or 40).employees are paid on normal hourly rate Design a PL/SQL program to calculate the gross salary of his employees (ie total salary) Guideline Use the following algorithm: 1. Get the number of hours worked. 2. Get the hourly pay rate. 3. If the employee worked more than 40 hours, calculate the gross pay with overtime. Otherwise, calculate the gross pay as usual
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
