Create an auditing policy that keep track of insertion

Assignment Help Computer Engineering

Reference no: EM132174958

Using SQL Developer

Your assignment is to create an auditing policy that keep track of insertion and update activities of Customers table. This Customers trigger fires before update or insert or delete on customers. You have to test your trigger and provide screenshots to prove that it works correctly

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

D2. Insert 2 rows into the Customers table.

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

D4. Create a trigger for auditing-create trigger audit_customers on the Custoners table

D5. Insert 3 records into the Customers table.

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

D5. Now update the zip code of one customer and check if rows were added to the customers table and that the trigger did populate the customers-history table with the new zip code.

D6. Update the first record of Customers, and then delete this record.

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

You have to provide the trigger code, code you used to create the table and insert records.

Reference no: EM132174958

Questions Cloud

How do the various components of the lymphatic system : How do the various components of the lymphatic system operate? We have talked about many organ systems.

What parts of the protein is most likely to be an epitope : What parts of the protein is most likely to be an epitope for a B cell? What parts of the protein is most likely to be an epitope for a T cell?

Implement a single object that implements enqueue : If you use my code make sure you are logged in to JSFiddle and you Fork the code over to your own.

Label the name of the enzyme : Draw a diagram of a cell showing the reactions of the urea cycle in the appropriate subcellular locations. Start with ammonium and end with urea.

Create an auditing policy that keep track of insertion : Create an auditing policy that keep track of insertion and update activities of Customers table.

Describe the movements of chromosomes in prophase : Describe the movements of chromosomes in prophase, metaphase, anaphase, and telophase of mitosis?

Write a program to test if a given input string containing : Using Stack ADT, write a program to test if a given input string containing the exactly one character ‘

Calculating n for a study of individuals : Since we are calculating n for a study of individuals, answers should be rounded up to the next whole number.

Devise a section of code that moves all of the integers : Assume startQ contains elements of type int and both evenQ and oddQ are empty. Devise a section of code that moves all of the integers from startQ.

User Account

All Pages