In databases, normalization is important


In databases, normalization is important. It avoids wasting space, and more importantly, avoids out-of-sync data.

On the UI, the same principle holds. A piece of data should be stored in one spot. Data stored in multiple spots is a bug waiting to happen.

Example, and solution:

View original on X