Your case might be a decent example of "Normalize until it hurts, de-normalize until it works". If storing a value solved a problem like this for me, I'd definitely do it but likely wouldn't use it.Db normalization is great in theory, but applying the theory can be tough for someone like me.