What is normalization?
Why is it important?
Read more below to find those answers.
Normalization put simply is making sure that values that should be the same are the same. If you've ever had recipes that use the gallons or ounzes but only have metric measuring cups, you have a practical example where non-normalized information causes problems.
This same sort of thing happens all the time in the world of information across different sources. You could have something as simple as one website having a rating scale from 1 to 5 and another that has 1 to 100 and need to compare them. The title field of documents could have different names from one system to another. Even within one database, there could still be tables that designate the fields differently. Normalization brings all of those varying and competeting lables, measurements, tags, etc. down to a single unified (or normalized) system.
Wouldn't it be great if the whole world used the metric system? We can at least make a single unifed system a reality for your data.