We always implement the normalization to the OLTP system, in which both the reading and writing activities are involved. Sometimes if we want to enhance the reading performance in some database system such as OLAP (datawarehouse,datamart), we have to do someting like de-nomalization. But no matter whether we de-nomalize or not, normalization should be implemented firstly during the designing process.