understanding the purpose and goals of normalization in database design, as well as the different normal forms and their key characteristics, potential trade-offs, and the concept of denormalization.

Assignment| – Normalization.
1. What is the purpose of normalization in databasedesign?
2. What are the main goals of normalization?
3. Define data redundancy and explain why it isimportant to eliminate or minimize it in a database.
4. What is the First Normal Form (1NF)? Describe the keycharacteristics and requirements of 1NF.
5. How does the Second Normal Form (2NF) differ from1NF? What problem does it address?
6. Explain the concept of functional dependencies andtheir role in normalization.
7. What is the Third Normal Form (3NF)? How does itbuild upon 2NF?
8. What are the potential trade-offs or challenges of over-normalization in database design?
9. Discuss the concept of denormalization and when it is appropriate to use it in database optimization.
10. Explain the importance of striking a balance between normalization and the specific needs of an application.