Well your constraints do prevent bad data. It certainly makes updates more of a pain to deal with. I guess the issue really is denormalization. There are certainly times when this is appropriate. I can't really hazard a guess if your situation is one of those or not because the sample tables are so simple. My guess is that because you are asking the question it probably is not the best way to proceed. Typically if something doesn't seem right, it probably isn't.