(Solved) : Need Help Homework Create Payroll Table Oracoo Company Contain Following Field Schema 10 3 Q28561981 . . . .

I need help with my homework.

Create a Payroll table for the ORACOOCompany that will contain the following field schema as of10/31/2011, and populate the table You may name the tablepayroll.

Name

Emp_id

Dep

Hourly_Rate

BiWeekly_Cur_Hours

Hire_ Date

Manager

John Doe

007

X

54.56

135

2/3/09

Betty

Davis

005

Y

14.56

80

1/21/99

John Doe

Joe Smith

003

Z

14.56

80

1/11/05

John Doe

Frank

Coole

001

Z

13.30

82

3/14/05

Joe Smith

Thomas

Crown

143

S

12.40

84

09/25/07

Frank

Coole

Sam

Honan

730

R

11.11

80

4/5/88

Frank

Coole

Mary

Nam

006

R

43.43

46

1/6/11

Betty

Davis

Diane

Baker

004

R3

44.50

110

1/2/94

Sam

Honan

Your Name

111

S

15.00

80

Today’s date

John Doe

Run the following reports for Oraco Company. Include titles,Today’s date, page number, column headings/formats where applicableon the report. Check the “Designing a Report in Oracle” document inthe Lecture Folder to help you with the code.

1>Creating a self join or a subquery (your choice):

Show which employees work for John Doe and Frank Coole.

2>Creating the bi-weekly Gross Pay payroll report for periodending 04/30/2016:

Show the