Answer to Question #262127 in Databases | SQL | Oracle | MS Access for Shanu

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.