These are the tables

create table EMP(empNo number(6) primary key,fname varchar(50),lname varchar(50),address varchar(50), sex varchar(1),salary decimal(15,2), position varchar(50),deptNo number(4));

create table DEPT(deptNo number(6) primary key,deptName varchar(50),Mgr number(6));

create table PROJ(projNo number(6) primary key,projName varchar(50),deptNum number(6));

create table EMP_PROJ(empno number(6),projNo number(6) ,hourSpent number(6));

I need #6-8 I NEED WORKING AND REAL SQL STATEMENTS.

6 Create a new table named emp_proj_overtime which have three columns of Details of the hours worked by the employee on each project (empNo, projNo) EMP_PROJ_O VERTIME empNo projNo hourot Unique id, format 9999 Unique id, format 9999 Number of overtime hours spent by the employee in the project 7 Assume each employee has a cap of 100 hours per project, develop a trigger to track overtime hours when employee exceed the cap for the project. 8 If the overtime pay is twice of regular hourly rate, modify the query from question 4 and add the factor of overtime. 6 Create a new table named emp_proj_overtime which have three columns of Details of the hours worked by the employee on each project (empNo, projNo) EMP_PROJ_O VERTIME empNo projNo hourot Unique id, format 9999 Unique id, format 9999 Number of overtime hours spent by the employee in the project 7 Assume each employee has a cap of 100 hours per project, develop a trigger to track overtime hours when employee exceed the cap for the project. 8 If the overtime pay is twice of regular hourly rate, modify the query from question 4 and add the factor of overtime