What is Normalization of database

Question

Hi!!

Can someone tell me what exactly does normalization mean and what are it's advantages?

Answer 1

Normalization is the process of organizing data to avoid duplication and redundancy. Some of the advantages are:

• Better Database organization
• More Tables with smaller rows
• Efficient data access
• Greater Flexibility for Queries
• Quickly find the information
• Easier to implement Security
• Allows easy modification
• Reduction of redundant and duplicate data
• More Compact Database
• Ensure Consistent data after modification