What is normalization in relational database?

Normalization is a process in relational database design aimed at organizing data to reduce redundancy and improve data integrity. It involves dividing a database into two or more related tables and defining relationships between them. The goal is to ensure that the database structure is efficient, minimizes data duplication, and maintains consistency.