Question

Create a trigger named trg_mem_balance that will maintain the correct value in the membership balance in the MEMBERSHIP table when videos are returned late. The trigger should execute as an AFTER trigger when the due date or return date attributes are updated in the DETAILRENTAL table. The trigger should satisfy the following conditions.
a. Calculate the value of the late fee prior to the update that triggered this execution of the trigger. The value of the late fee is the days late times the daily late fee. If the previous value of the late fee was null, then treat it as zero (0).
b. Calculate the value of the late fee after the update that triggered this execution of the trigger. If the value of the late fee is now null then treat it as zero (0).
c. Subtract the prior value of the late fee from the current value of the late fee to determine the change in late fee for this video rental.
d. If the amount calculated in part c is not zero (0), then update the membership balance by the amount calculated for the membership associated the rental that this detail is a part of.



$1.99
Sales1
Views108
Comments0
  • CreatedDecember 03, 2014
  • Files Included
Post your question
5000