Referential integrity saves you so many headaches. I am dealing with a 500+ table database with no foreign keys at all. This has allowed so many problems to creep in. Writing queries is pure suffering.