Employee Spend overtime increse salary double then norma sa

Question

Hai to All.....

 

Write a Stored procedure in SQL Employee working more then 8 howers. Every one hower this

Salary is double than normal howers (Daily working howers is 8 howers)

 

create three tables: 1.Shifts,2.employee,3.timesheet 

Insert into shift values(emp_code  int,shift_name varchar(),shift_time time);

Insert into employee values(emp_code int,emp_name varchar(),grade varchar(),dept varchar(),  salary int); 

Insert into timesheet values(emp_code int,date _in date,time_in time,time_out time,date_out date);

 Using above Three table  and write SP

Example: 

 Per day normal working howers is :8 howers

per howers salary 100 rupes

Daily salary =8*100=800

Spend extra 1 hower =1*100 (normal salary)+salary double

                                      =1*100+100=200

Spend extra 2 howers=2*100 (normal salary)+salary double

                                      =2*100=200+200(salary double)=400

Plz Send Stored procedure in SQL ((Using above  Three Tables))

 

Thanks and regard's

 

Venkatesh D