Delete and Update of Foreign keys
The trick is to not actually delete rows, but to set an "IsDeleted" column to 1. That way, referring records remain unorphaned. 

Updates are more interesting. Do you need to have the referring record still refer to the old record, or the new version?