What is Database Normalization? Database normalization is a process in which a database is restructured in accordance with some normal forms. This helps to reduce data redundancy and to improve the integrity of data. Normalization takes into account that the attributes and relations of a database are according to the data integrity constraints. Two formal rules accomplish database normalization. These are 1) Synthesis: In this rule, a new database design is created. 2) Decomposition: In this rule, an existing database…