Joshua Allen has a nice post about data normalisation. He suggests that sometimes it is necessary for performance and scalability reasons that you don't fully normalise your data schema. This is something I've run into occasionally too but, as I recall, isn't something that was taught in the academic database design courses I attended way back when.