2. Create a trigger 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 FOR/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. e) Test your trigger
2. Create a trigger 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
FOR/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.
e) Test your trigger
Step by step
Solved in 3 steps with 2 images