Explain the normalization and why it is done. explain the case when we avoid the normalization in database.

Like in case of datawarehousing operation the no of tables to be joined to get the desired output might be too high. In such a case we de-normalize to serve our purpose.