I have this task to emulate a referential action with a trigger. The task itself is: Give an example of how to use a trigger to emulate a referential action.
I know hot to use triggers and referential actions but combined I just don't really get it, and the question itself.
Given that the least objectionable of the options you listed is to do a cascading delete when a parent row is removed