Normalization is the process of organizing data in a relational database so that it is stored and maintained efficiently. The goal of normalization is to eliminate data redundancy and inconsistencies by breaking down a large table into smaller, more manageable tables and establishing relationships between them