Question: design PL/SQL query with output in oracle . dont give answer in python or java please Chris owns auto repair business wants to calculate the

design PL/SQL query with output in oracle . dont give answer in python or java please

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. (i.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)

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!

WRITE PL/SQL query with output in oracle software. don't give answer in any other programming language like python or java Chris owns auto repair business wants to calculate the weekly salary of...

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 1. If an employee works over 40 hours in a...

The Purpose of the Romeo Engine Plant is to produce the highest quality production engines in the world that meet all of our customers' requirements at a cost lower than the competition, and to...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

In the Intro to Purchasing and Supply Chain reading, Page 6, Figure 1-2, there is a comparison of Traditional Purchasing versus the Current Outlook. Provide three reasons why the Current Outlook is...

Midterm Examination Questions - Spring 2016 1. The final examination grades of random samples of students from three different classes are shown below. Class A Class B Class C 92 91 85 85 85 93 96 90...

Your end-of-semester assignment is as follows: (a) (i) read the two Economist articles entitled ?Debt is Good for You? (dated 01/25/2001) and ?Debtors? Prison? (dated 02/09/2009), which discuss the...

Methyl alcohol (CH3OH) is burned with 100 percent excess air. During the combustion process, 60 percent of the carbon in the fuel is converted to CO2 and 40 percent is converted to CO. Write the...

FlatScreen manufactures flat-panel LCDdisplays. The displays are sold to major PC manufacturers. Following are some manufacturingoverhead data for FlatScreen for the year ended December 31, 2013:...

4.43 The length of time, in minutes, for an airplane to obtain clearance for takeoff at a certain airport is a random variable Y = 3X 2, where X has the density function f(x) = 14 e x/4, x>0 0,...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Why is the System Build Process an iterative process?

What phase normally comes directly after the System Build process in a Project?

Name two other algorithms available in SSAS Data Mining other than Decision Trees.