I'm preparing a user group presentation on database normalization. I would like to show examples of different challenging 1NF conversions.
Tackling 1NF conversions of unstructured/delimited data is a different animal that I will tackle separately. What I would like to see from you are different repeated group column names that you've encountered.
Sequential numbering is usually what the students see. I'd like to show them more challenging examples from your real-world experiences. Things that come to mind are year and quarter values, week values, month name values, and day name values. Other challenges might be values that aren't at the end of a column name, capitalization, and no delimiter between the root column name and the serialization values.