Question: 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

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 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!

3 . Create a table "contacts" which includes contact _ id ( integer type ) , first _ name ( character data type of length 3 0 ) , last _ name ( character data type of length 2 5 ) . a ) Create a...

PART 1: ALREADY COMPLETED. NEED PART 2 Tasks Query Description SQL Statement Create a new database in MySQL called horsestable. List the databases in MySql. Result set should look like: Create...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Project 2 50 points Building upon your project 1, the park will be a Star Wars themed park. You must design additional parts of the database and create the following SQL Script. Step 1: Design and...

1. Your company uses 2 tables to store product information named LocalProducs and InternationalProducts. You also use a table named Orders that stores open order information. You must retrieve the ID...

(the bottom two tables in red text which are hard to read are the "image" table and "message_image" table respectively) USE "messaging" database Task 1: Insert Record to the Person Table Construct...

PLEASE HELP WITH ASSIGNMENT!!!!! (the bottom two tables in red text which are hard to read are the "image" table and "message_image" table respectively) USE "messaging" database Task 1: Insert Record...

Questions & Tasks 1. Create a table named DEPT based on the following chart. Column Name ID NAME Primary key Key Type Nulls/Unique FK Table FK Column Data type NUMBER VARCHAR2 Length 25 Name Null...

Written in Java. Please help. Any information would be greatly appreciated. Even shelling of the code would be beneficial if you cannot understand the whole thing. Thank you!!!!!!!!!!!!!!!!!! Example...

Assignment 4-12: Using a Cursor Variable Create a block with a single cursor that can perform a different query of pledge payment data based on user input. Input provided to the block includes a...

Should the component costs be figured on a before-tax or an after-tax basis?

For many employeesand especially working parentsthe best time of the day to really get some quality work done comes when they are out of the office and the kids are asleep. This is the new 9 to 11 PM...

Current Attempt in Progress If a company holds a debt until maturity, how should the extinguishment of debt be recorded? The unamortized premium will be recorded as a loss on extinguishment. The...

The CEO of Grooms Incorporated wants to ensure coordination across the firm's geographically dispersed locations. She can achieve unified action by

Recent research suggests that career plateaus are more complex than previously thought. Briefly explain why an individuals perception of being plateaued is important and how organizations may want to...

Explain how both organizations and individuals can benefit from a well designed career management system.

Explain why management development is one of the most common HRD activities found in organizations today.