Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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));
PLEASE HELP ME WITH #6-8 I need the SQL STATEMENTS. THANK YOU WILL UPVOTE FOR ANSWERS!
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 overtimeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started