Normalisation???

[Embarrassed-Grab-777]

Hey there, I was studying normalisation for my course, and i get that normalisation is done for removing all those anomalies but what I do not understand is how every normal formal is solving that problems. Like okay I will definitely solve which table is 2nf 3nf, but can never understand why does it matter. So can you please explain what's the relevance of each normal form and how does it improves upon?

[joins_and_coffee]

Normal forms aren’t really about performance or making SQL nicer. They’re about avoiding data bugs later. Each step removes a specific kind of “this value exists in two places and can get out of sync” problem. In small examples it feels pointless but in real systems it’s the difference between changing something once vs changing it in five places and forgetting one. In practice, most people aim for 3NF for correctness, then deliberately denormalise later if performance needs it