- Home
- Bengal Math Curriculum
- Statistics Help
- Statistics Consulting
- Popular Services
- *99 Cents for 1 Math Problem
- Statistics Help
- Statistics Solutions
- Statistics Symbols
- Statistics Lecture Notes
- Statistics Class Notes
- Hire Freelancer - xlance Alternative
- Math Olympiad
- Free Accounting Homework Help
- Free Business Math Homework Help
- Free Programming Homework Help
- Free Finance Homework Help
- Free Economics Homework Help
- Free Chemistry Homework Help
- Free Biology Homework Help
- Free Management Homework Help
- Free Engineering Homework Help
- Free Chemical Engineering Homework Help
- Free Mechanical Engineering Homework Help
- Free Computer Science Homework Help
- Free Bioinformatics Homework Help
- Free Calculus Homework Help
- Free College Homework Help
- Get One Month Coaching ($149)
- Math Curriculum(High Expectation)
- 1-On-1 Coaching
- Accounting Solutions
- Bioinformatics Solutions
- Biology Solutions
- Business Math Solutions
- Calculus Solutions
- Chemical Engineering Solutions
- Chemistry Solutions
- Computer Science Solutions
- Economics Solutions
- Engineering Solutions
- Finance Solutions
- Management Solutions
- Mechanical Engineering Solutions
- Programming Solutions
- Donate
- Almost FREE Service
- Chat Core Dump
- WhiteBoard Sessions
- Submit Math Problems
- Checkout Math Solutions
- Sample Math Video
- College Textbooks
- College Courses
- Coursera Courses
- edX Courses
- Give Gift Certificates to Your Loved One
- Get a Scholarship
- Tell a Friend
- *Online Math Help ($16 per Hour)
- Vedic Maths
- Home Schooling
- Community College Math
- Online Degree Program
- Blog
- We are in News
- FAQ
- Contact Us
- Privacy Policy
- Terms & Condition * Restrictions Apply

- Home
- *99 Cents for 1 Math Problem
- Statistics Help
- Statistics Solutions
- Statistics Symbols
- Statistics Lecture Notes
- Statistics Class Notes
- Hire Freelancer - xlance Alternative
- Math Olympiad
- Free Accounting Homework Help
- Free Business Math Homework Help
- Free Programming Homework Help
- Free Finance Homework Help
- Free Economics Homework Help
- Free Chemistry Homework Help
- Free Biology Homework Help
- Free Management Homework Help
- Free Engineering Homework Help
- Free Chemical Engineering Homework Help
- Free Mechanical Engineering Homework Help
- Free Computer Science Homework Help
- Free Bioinformatics Homework Help
- Free Calculus Homework Help
- Free College Homework Help
- Get One Month Coaching ($149)
- Math Curriculum(High Expectation)
- 1-On-1 Coaching
- Accounting Solutions
- Bioinformatics Solutions
- Biology Solutions
- Business Math Solutions
- Calculus Solutions
- Chemical Engineering Solutions
- Chemistry Solutions
- Computer Science Solutions
- Economics Solutions
- Engineering Solutions
- Finance Solutions
- Management Solutions
- Mechanical Engineering Solutions
- Programming Solutions
- Almost FREE Service
- Chat Core Dump
- WhiteBoard Sessions
- Submit Math Problems
- Checkout Math Solutions
- Sample Math Video
- College Textbooks
- College Courses
- Coursera Courses
- edX Courses
- Give Gift Certificates to Your Loved One
- Get a Scholarship
- Tell a Friend
- *Online Math Help ($16 per Hour)
- Vedic Maths
- Home Schooling
- Community College Math
- Online Degree Program
- Blog
- We are in News
- FAQ
- Contact Us
- Privacy Policy
- Terms & Condition * Restrictions Apply

Statistics Help

**Question: **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. (2 points) Edit

**TutorTeddy.com & Boston Predictive Analytics**

[ Email your Statistics or Math problems to **help@teddycan.com** (camera phone photos are OK) ]

Boston Office (Near MIT/Kendall 'T'):

Cambridge Innovation Center,

One Broadway, 14th Floor,

Cambridge, MA 02142,

Phone: 617-395-8864

Dallas Office (Near Galleria):

15950 Dallas Parkway,

Suite 400,

Dallas, TX 75248,

Phone: 866-930-6363