Write the code for the following triggers in MySQL, PL/SQL, or T-SQL following the style shown in the text.a. When adding a customer, add the customer’s balance multiplied by the sales rep’s commission rate to the commission for the corresponding sales rep.b. When updating a customer, add the difference between the new balance and the old balance multiplied by the sales rep’s commission rate to the commission for the corresponding sales rep.c. When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.

According to the explanation given:- we have to create triggers Statement.

Answered: Write the code for the following…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Write the code for the following triggers in MySQL, PL/SQL, or T-SQL following the style shown in the text.
1. a. When adding a customer, add the customer’s balance multiplied by the sales rep’s commission rate to the commission for the corresponding sales rep.
2. b. When updating a customer, add the difference between the new balance and the old balance multiplied by the sales rep’s commission rate to the commission for the corresponding sales rep.
3. c. When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.

Expert Solution