I've worked on several large SQL systems and while I've seen plenty of foreign key constraints in use I've never actually seen them do anything besides cause problems during dataloads and ad-hoc ...