Question: 3 . Create a table contacts which includes contact _ id ( integer type ) , first _ name ( character data type of length

3. Create a table "contacts" which includes contact_id (integer type), first_name (character data type of length 30), last_name (character data type of length 25).
a) Create a trigger to insert contact_id, created_by, creation_date into contacts_audit table after inserting rows into contacts table. created_by
in contacts_audit table is the full name taken from first_name and last_name of table contacts.
b) Create a trigger to insert contact_id and deletion_date before any row is getting deleted from contacts table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To accomplish the tasks outlined in your question lets break it down into steps and ensure each part is handled correctly Step 1 Create the contacts T... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!