ONLY DO THIS USING SQL DEVELOPER (ORACLESQL).

And using the following tables (Tables for Part 1 and2):

CREATE TABLE Customers
(
Cust_id int PRIMARY KEY,
Last_Name varchar(255),
First_Name varchar(255),
State varchar(255),
Zipcode Number(10)
);

CREATE TABLE Customers_history
(
History_id int PRIMARY KEY,
Cust_id int,
Last_Name varchar(255),
First_Name varchar(255),
State varchar(255),
Zipcode Number(10)
);

TEST CODE BEFORE POSTING SOLUTION.

Your assignment is to create an auditing policy that keeptrack of insertion and update activities of Customers table. ThisCustomers trigger fires before update or insert or delete oncustomers. You have to test your trigger and provide screenshots toprove that it works correctly

D1. Create a new table named Customers. Thenew table should have at least 5 columns including a primary key.(Cust-id, First_name, Last_name, State, Zip-code. Use cust_id asPK.

D2. Insert 2 rows into the Customers table.

D3. Create a history table for Customers table, (createtable customers_history). The table should have same structure asCustomers table Cust-id + First_name + Last_name+ State + Zip_code.Don't forget the history_id as pk . Do NOT insert anydata (values) into this table.

D4. Create a trigger for auditing?create triggeraudit_customers on the Custoners table

D5. Insert 3 records into the Customers table.

D4. Retrieve all rows from customers and customers-historytable to verify that rows were added to the Customers table andthat the trigger is populating the customers-historytable.

D5. Now update the zip code of one customer and check ifrows were added to the customers table and that the trigger didpopulate the customers-history table with the new zipcode.

D6. Update the first record of Customers, and then deletethis record.

D7. Display the content of Customers table and the historytable.

You have to provide the trigger code, code you used to createthe table and insert records. (2 points)

Answer rating: 100% (QA)

ANSWER D1 Create a new table named Customers The new table shouldhave at least 5 columns including a primary key Custid Firstname Lastname State Zipco... View the full answer