I am designing a spatial database and I am including a variety of already existent datasources (ex: Lakes, rivers, road network, contour lines, cities, etc). Those sources can be updated every once in a while.
Except from these sources, the database is normalized in fifth normal form (5NF) or Boyce-Codd normal form (BCNF).
Should I also normalize those external datasources?
My concern is that it may be too much trouble for the benefits. I am thinking about the moment when I will update the sources. It would be much more trouble than to just "replace" the existing table.