Question

Explain data normalization with examples. 

Answer 1

Data normalization is the process of organizing non structured data into organized data in related table this improves integrity and reduces redundancy when processing data in a database.

e.g In 1NF all repeated fields are put in separate tables and assigning appropriate keys to them to avoid redundancy.