I do some part-time work at a non-profit that, ultimately, does super-international (30+ countries) surveys. As you might imagine, this results in a massive database and my main duty is wrangling the data into a .csv-friendly format.
One of the quick things we learned that "normalization" in the naive sense was an exercise in idiocy.
Breaking names into 'first name' and 'last name'? Hah, right.
Breaking locations into 'country', 'state', and 'city'? Hah, right.
The big solution: don't constrain what someone types in. Constrain how you work with it.