- Develop two database triggers that will update the employee audit table and employee deduction audit table when rows are either changed or deleted. Use a sequence number to assign a unique identifier to each row as it is created in the audit table. Capture the user ID, date of the change or delete, and action (update or delete), plus all the fields in the before image of the row (e.g. before it is changed or deleted).
CREATE TABLE emp_audit (
CREATE TABLE emp_deductions_audit (
Recently Asked Questions
- Please refer to the attachment to answer this question. This question was created from SAB CHCCCS015 Provide individualised support.docx.
- The increase in oil production in the United States characterizes which of the following key financial concepts presented in this book? Multiple Choice the
- I am looking for help on my week 3 case study, Industrialization.