Normalization

Question

benefit of normalization?

performance is improved

insertion anomalies are avoided.

none

Answer 1

Answer : insertion anomalies are avoided.along with it

1. The database does not have redundant data, it is smaller in size so less money needs to be spent on storage
 
2. Because there is less data to search through, it is much faster to run a query on the data
 
3. Because there is no data duplication there is better data integrity and less risk of mistakes.
 
4. Because there is no data duplication there is less chance of storing two or more different copies of the data
 
5. Once change can be made which can instantly be cascaded across any related records.

Answer 2

Normalization reduces insertion /updation anomalies but also reduces speed  as more tables are created so data access become slow  although complete redundancy is not removed but still it is minimized