Let us consider a case where we want to keep audit trail for every record being inserted in COMPANY table. To keep audit trail, we will create a new table called AUDIT where the log messages will be inserted, whenever there is an entry in COMPANY table for a new record.

For the given Company database

Create the following tables

$1.$ Table COMPANY with the following fields, employee$\_$id$,$ first$\_$name, last$\_$name $,$ email, phone$\_$number, hire$\_$date, job$\_$id$,$ salary, commission$\_$pct$,$ manager$\_$id$,$ and department$\_$id

$2.$ Table AUDIT which have three fields emp$\_$id$,$ salary and edit$\_$time

Write the following triggers:

$1.$ Whenever an employee data is inserted into the COMPANY table a corresponding entry must be made in the AUDIT table.

$2.$ Whenever an update is made to the salary attribute of the COMPANY table, the update must also reflect in the AUDIT table.

Let us consider a case where we want to keep audit trail for every record being inserted in COMPANY table. To keep audit trail, we will create a new table called AUDIT where the log messages will be inserted, whenever there is an entry in COMPANY table for a new record.

For the given Company database

Create the following tables

$1.$ Table COMPANY with the following fields, employee$\_$id$,$ first$\_$name, last$\_$name $,$ email, phone$\_$number, hire$\_$date, job$\_$id$,$ salary, commission$\_$pct$,$ manager$\_$id$,$ and department$\_$id

$2.$ Table AUDIT which have three fields emp$\_$id$,$ salary and edit$\_$time

Write the following triggers:

$1.$ Whenever an employee data is inserted into the COMPANY table a corresponding entry must be made in the AUDIT table.

$2.$ Whenever an update is made to the salary attribute of the COMPANY table, the update must also reflect in the AUDIT table.