Suppose I have a bi-directional for many-to-many or one-to-many relation (i.e. each side have access to the other). For many-to-many and one-to-many there is always an "owner" and a non-owner. Should "CASCADE" only be specified on the owner side ? what happens if
1) CASCADE is specified on both owner and non owner side ?
2) CASCADE is specified on non owner side only ?