PL-SQL

Problem 1

Create a trigger named Lab3Trigger1

You must place a copy of student.employee into your table space before compiling this trigger.

This trigger will add a new employee to the employee_copy table after a delete on the employee_copy table takes place.

Problem 2

Create a trigger named Lab3Trigger2

If the employee_copy table has less than 20 rows, do not allow a delete on the employee_copy table

to take place.

When you cause this trigger to execute, you should receive the following error. Notice that this is a

custom error of your making.

SQL Error: ORA-20101: Less than 20 rows in employee_copy table. No delete allowed.

STUDENT GRADE NUMBER(B) NUMBER (B) STUDENT.GRADE TYPE WEIGHT STUDENT ID SECTION_ID GRADE TYPE COCE ORADE_CODE_OCCURRENCE NUMBER(3) NUMERIC COMMENTS CREATED BY CRFATFD_DATF GRADE TYPE_CODE CHAR (2 BYTE CREATED BY MODIFIED_BY CHAR (2 BYTE GRADE TYPE_CODE PERCENT OF_FINAL GRADE NUMBER (3) CREATED BY ECTION VARCHAR2 (3D BYTE NUMBER (3) VARCHAR2 2000 BYTE) VARCHAR2 (30 BYTE) VARCHAR2 (3D BYTE VARCHAR2 (30 BYTE) GRTYP_PK (GRADE TYPE_CODE) DATE MODIFIED DATE GRTW_PK(SECTION ID GRADE_TYPE_CoDE) GRTW GRTYP FK (GRADE_TYPE_CODE) MODIFIED_DATE GR PK(STUDENT ID. SECTION ID. GRADE_TYPE_CODE. GRADE_CODE_OCCURRENCE) OR ENR_FK (STUDENT ID. SECTION D) GR GRTW FK(SECTION ID, GRADE TYPE CODE GATW SECT FK (SECTION ID) STUDENT.ENROLLMENT STUDENT STUDENT STUDENT.ZIPCODE NUMBER () NUMBER (8) PF" STUDENT ID STUDENT ID SALUTATION NUMBER(B) VARCHAR2 (5 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (60 BYTE) VARCHAR2 (5 BYTE) VARCHAR2 [16 BYTE) VARCHAR2 (50 BYTE) SECTION I ENROLL DATE VARCHAR2 (25 BYTE) VARCHAR2 (30 BYTE) VARCHAR2 (30 BYTE) GRADE NUMBER (3) VARCHAR2 (30 BYTE) CREATED_BY STREET ACDRESS a P PHONE CREATED DATE DATE MODIFIED_BY MODIFIED DATE DATE ENR PK (STUDENTD, SECTION ID) ENR SECT FK(SECTION ID) VARCHAR2 (30 BYTE) REGISTRATION DATE DATE CREATED CREATED_CATE MODIFIED_BY MODIFIED DATE VARCHAR2 (30 BYTE) STUDENT INSTRUCTOR STU PK (STUDENT ID INSTRUCTOR ID SALUTATION VARCHAR2 (5 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (5 B VARCHA2 (OD BYTE) STREET ADDRES ZIP SECTION ID COURSE NO SECTION NO START DATE TIME DATE LOCATION INSTRUCTOR ID CAPACITY CREATED BY CREATED_DATE MODIFIED BY MODIFIED_DATE CREATED BY CREATED DATE VARCHAR2 BYTE) DATE VARCHAR2 BYTE) STUDENT COURSE VARCHAR2 (50 BYTE) COURSE NO DESCRIPTION COST PREREQUISITE NUMBER(8) CREATEC BY CREATEC DATE DATE VARCHAR2 (EO BYTE MODIFIED DATE INST PK (INS TRUCTOR ID) VARCHAR2 (30 BYTE) VARCHAR2 (30 BYTE) INST-ZIP-FK (21P) VARCHAR2 (30 BYTE VARCHAR2 (30 BYTE) MODIFIED DATE DATE SECT_PK(SECTION ID) CRSE_PK COURSE_NO) SECT CRSE_FK (COJRSE NO) SECT INST_FK (INS RUCTOR ID) CRSE_CRSE_FK PREREQUISITE) STUDENT GRADE NUMBER(B) NUMBER (B) STUDENT.GRADE TYPE WEIGHT STUDENT ID SECTION_ID GRADE TYPE COCE ORADE_CODE_OCCURRENCE NUMBER(3) NUMERIC COMMENTS CREATED BY CRFATFD_DATF GRADE TYPE_CODE CHAR (2 BYTE CREATED BY MODIFIED_BY CHAR (2 BYTE GRADE TYPE_CODE PERCENT OF_FINAL GRADE NUMBER (3) CREATED BY ECTION VARCHAR2 (3D BYTE NUMBER (3) VARCHAR2 2000 BYTE) VARCHAR2 (30 BYTE) VARCHAR2 (3D BYTE VARCHAR2 (30 BYTE) GRTYP_PK (GRADE TYPE_CODE) DATE MODIFIED DATE GRTW_PK(SECTION ID GRADE_TYPE_CoDE) GRTW GRTYP FK (GRADE_TYPE_CODE) MODIFIED_DATE GR PK(STUDENT ID. SECTION ID. GRADE_TYPE_CODE. GRADE_CODE_OCCURRENCE) OR ENR_FK (STUDENT ID. SECTION D) GR GRTW FK(SECTION ID, GRADE TYPE CODE GATW SECT FK (SECTION ID) STUDENT.ENROLLMENT STUDENT STUDENT STUDENT.ZIPCODE NUMBER () NUMBER (8) PF" STUDENT ID STUDENT ID SALUTATION NUMBER(B) VARCHAR2 (5 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (60 BYTE) VARCHAR2 (5 BYTE) VARCHAR2 [16 BYTE) VARCHAR2 (50 BYTE) SECTION I ENROLL DATE VARCHAR2 (25 BYTE) VARCHAR2 (30 BYTE) VARCHAR2 (30 BYTE) GRADE NUMBER (3) VARCHAR2 (30 BYTE) CREATED_BY STREET ACDRESS a P PHONE CREATED DATE DATE MODIFIED_BY MODIFIED DATE DATE ENR PK (STUDENTD, SECTION ID) ENR SECT FK(SECTION ID) VARCHAR2 (30 BYTE) REGISTRATION DATE DATE CREATED CREATED_CATE MODIFIED_BY MODIFIED DATE VARCHAR2 (30 BYTE) STUDENT INSTRUCTOR STU PK (STUDENT ID INSTRUCTOR ID SALUTATION VARCHAR2 (5 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (5 B VARCHA2 (OD BYTE) STREET ADDRES ZIP SECTION ID COURSE NO SECTION NO START DATE TIME DATE LOCATION INSTRUCTOR ID CAPACITY CREATED BY CREATED_DATE MODIFIED BY MODIFIED_DATE CREATED BY CREATED DATE VARCHAR2 BYTE) DATE VARCHAR2 BYTE) STUDENT COURSE VARCHAR2 (50 BYTE) COURSE NO DESCRIPTION COST PREREQUISITE NUMBER(8) CREATEC BY CREATEC DATE DATE VARCHAR2 (EO BYTE MODIFIED DATE INST PK (INS TRUCTOR ID) VARCHAR2 (30 BYTE) VARCHAR2 (30 BYTE) INST-ZIP-FK (21P) VARCHAR2 (30 BYTE VARCHAR2 (30 BYTE) MODIFIED DATE DATE SECT_PK(SECTION ID) CRSE_PK COURSE_NO) SECT CRSE_FK (COJRSE NO) SECT INST_FK (INS RUCTOR ID) CRSE_CRSE_FK PREREQUISITE)