A Guide to SQL (9th Edition) Chapter 8, Problem 8SCG

Assume the OWNER table contains a column named TOTAL_FEES that represents the total monthly condo fee for all condos owned by that owner. Write the code in PL/SQL or T-SQL for the following triggers following the style shown in the text.

a. When inserting a row in the CONDO_UNIT table, add the condo fee to the total condo fees for the appropriate owner.

b. When updating a row in the CONDO_UNIT table, add the difference between the new condo fee and the old condo fee to the total condo fees for the appropriate owner.

c. When deleting a row in the CONDO_UNIT table, subtract the condo fee from the total condo fees for the appropriate owner.