What is normalization?

Question

Need a detailed elaboration of types of normal forms and how it affects database..

Answer 1

Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables.