Question: PL/SQL and Triggers Could I please get help on these problems? Thank you 1 (PL/SQL Programming) Consider the table EMPLOYEE with attributes ID, Name, and
PL/SQL and Triggers
Could I please get help on these problems? Thank you





1 (PL/SQL Programming) Consider the table EMPLOYEE with attributes ID, Name, and Hours, and the table PAYDATA with attributes Regular, Overtime, and Cutoff, defined and populated by the following script: DROP TABLE EMPLOYEE CASCADE CONSTRAINTS; CREATE TABLE EMPLOYEE I D Name Hours CHAR (7) , VARCHAR2 (12), NUMBER (3), CONSTRAINT PK EMPLOYEE PRIMARY KEY (ID) INSERT INTO EMPLOYEE VALUES ('7174311', "Pierson', 50) INSERT INTO EMPLOYEE VALUES ('0133899', 'Schneider', 20) INSERT INTO EMPLOYEE VALUES '6175427', 'Strickland', 25); INSERT INTO EMPLOYEE VALUES ('9714828', 'Wilson', 35) SELECT FROM EMPLOYEE; DROP TABLE PAYDATA; CREATE TABLE PAYDATA Regular Overtime Cutoff NUMBER (4,2), NUMBER (4, 2), NUMBER (2) INSERT INTO PAYDATA VALUES (12.00, 15.00, 30) SELECT * FROM PAYDATA; COMMIT Write a script file Problem1.sql containing an anonymous PL/SOL block that will do the following: 1 (PL/SQL Programming) Consider the table EMPLOYEE with attributes ID, Name, and Hours, and the table PAYDATA with attributes Regular, Overtime, and Cutoff, defined and populated by the following script: DROP TABLE EMPLOYEE CASCADE CONSTRAINTS; CREATE TABLE EMPLOYEE I D Name Hours CHAR (7) , VARCHAR2 (12), NUMBER (3), CONSTRAINT PK EMPLOYEE PRIMARY KEY (ID) INSERT INTO EMPLOYEE VALUES ('7174311', "Pierson', 50) INSERT INTO EMPLOYEE VALUES ('0133899', 'Schneider', 20) INSERT INTO EMPLOYEE VALUES '6175427', 'Strickland', 25); INSERT INTO EMPLOYEE VALUES ('9714828', 'Wilson', 35) SELECT FROM EMPLOYEE; DROP TABLE PAYDATA; CREATE TABLE PAYDATA Regular Overtime Cutoff NUMBER (4,2), NUMBER (4, 2), NUMBER (2) INSERT INTO PAYDATA VALUES (12.00, 15.00, 30) SELECT * FROM PAYDATA; COMMIT Write a script file Problem1.sql containing an anonymous PL/SOL block that will do the following
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
