Your Daily Cup of WTF - tblState
Naturally, all tables referencing tblState link with a column “intStateID”
Now, I don't know about you, I think you'd be a fool to implement this any other way. Think about it, what happens if a state descides to change it's name and abbreviation ... and the database you moved to when this happens does support update triggers? Can you really afford to take that risk? I didn't think so!