"Exercise $1$

User u$1/$p$1$ have created the following table and inserted rows

EMP$1($ EMPNO NUMBER$(4),$

ENAME VARCHAR$2(20),$

JOB VARCHAR$2(20),$

SAL NUMBER$(4),$

DEPTNO NUMBER$(2))$

Create a table ARCHIVE$\_$EMP$1$ with the same schema as the table EMP$1$

For archive purpose, develop a TD$19$ trigger that records into ARCHIVE$\_$EMP$1$ every deleted Employee.

Exercise $2$

Develop a trigger that forbids any modification of the employees$$ salary.

Create the table AUDIT$\_$EMP$1\_$SAL$($

Uname VARCHAR$(30),$

ChangeDate DATE,

OldSal NUMBER$(4),$

NewSal NUMBER$(4),$

DayNo NUMBER$(1))$

Develop a trigger that records any change of salaries done during the weekends $($assumed as days $6$ & $7$ of week$)$ into the table AUDIT$\_$EMP$1\_$SAL"