Problem details

Imagine if someone designed our post table (omitting certain columns) in the following way:

I hope you noticed the inconsistent superhero names in the first column (and captain's consistent lack of patience).

If we were to look at the first column, we are not sure which spelling is correct — Captain Temper or Capt. Temper. This is the kind of data redundancy that we would like to eliminate through normalization.