Write answer of the following questions:

1. What are the problems that we try to overcome with normalization?
2. How many total normal forms that exist? Why do we normally stop our normalization process at the 3.5 normal form (BCNF)?
3. What are the advantages and disadvantages of normalization?
4. Given that normalization comes with an expense, why is it still necessary to normalize our database?

Answer rating: 100% (QA)

When it comes to database design normalization is the process of structuring data in a way that eliminates redundancy and minimizes data anomalies It helps ensure data integrity improve query efficien... View the full answer