Write the code for the following triggers following the style shown in the text. a. When adding

Question:

Write the code for the following triggers following the style shown in the text.
a. When adding a customer, add the customer’s balance times 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.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts of Database Management

ISBN: 978-111182591

7th edition

Authors: Philip J. Pratt, Joseph J. Adamski

Question Posted: