Database Reference
In-Depth Information
b. Create a data macro associated with the After Insert event for the MarinaSlip table to implement the trigger
in Step 12a. Test the data macro by adding a row to the MarinaSlip table and ensuring that the TotalRental
field for the corresponding owner is updated correctly.
c. Create a data macro associated with the After Update event for the MarinaSlip table to implement the trig-
ger in Step 12b. Test the data macro by changing the rental fee on a row in the MarinaSlip table and
ensuring that the TotalRental field for the corresponding owner is updated correctly.
d. Create a data macro associated with the After Delete event for the MarinaSlip table to implement the
trigger in Step 12c. Test the data macro by deleting a row from the MarinaSlip table and ensuring that
the TotalRental field for the corresponding owner is updated correctly.
153
