Chapter 5, Problem 19E

Explanation of Solution

How to use trigger mechanism for delete cascade option:

• The triggers are defined for each relation whose primary-key is referred to be the foreign-key of some other relations.
• Whenever the tuple is deleted from the referred-to relation, the trigger should be started...