Wei,
> Does ON DELETE CASCADE attribute you specify in CREATE TABLE> statement> actually create triggers for every foreign key it refers to?>
Yes. Two triggers for each key, I think.
-Josh