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

write PL/SQL query with output in oracle
write PL/SQL query with output in oracle Chris owns auto repair business

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!