Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design – to enhance performance.The sacrifice to performance is that you increase redundancy in database.

Denormalization in database management refers to the process of intentionally introducing redundancy into a database design, usually for performance reasons. This involves adding redundant data to one or more tables within the database to help optimize read performance, simplify queries, or reduce the number of joins needed to retrieve data. While normalization aims to eliminate redundancy and maintain data integrity, denormalization sacrifices some of these benefits in favor of improved performance. It’s commonly used in situations where there’s a heavy emphasis on read operations, such as data warehouses or reporting systems.