I have the following data, and I was wondering if I should create a ErosionRateType and ErosionModel (with name and rate type) table or just leave the data as is since we are only going to have 3 erosion models at max. Btwm geography is an id field to the geography table.
Example data
Geography | Year | ErosionModel | RateType
==============================================================
France 1 GenericErosion Aggressi
France 2 GenericErosion Aggressi
France 3 GenericErosion Aggressi
France 4 GenericErosion Aggressi
France 1 GenericErosion Moderate
France 2 GenericErosion Moderate
France 3 GenericErosion Moderate
France 4 GenericErosion Moderate
USA 1 GenericErosion Aggressi
USA 2 GenericErosion Aggressi
USA 3 GenericErosion Aggressi
USA 4 GenericErosion Aggressi
USA 1 GenericErosion Moderate
USA 2 GenericErosion Moderate
USA 3 GenericErosion Moderate
USA 4 GenericErosion Moderate
Example data
Geography | Year | ErosionModel | RateType
==============================================================
France 1 GenericErosion Aggressi
France 2 GenericErosion Aggressi
France 3 GenericErosion Aggressi
France 4 GenericErosion Aggressi
France 1 GenericErosion Moderate
France 2 GenericErosion Moderate
France 3 GenericErosion Moderate
France 4 GenericErosion Moderate
USA 1 GenericErosion Aggressi
USA 2 GenericErosion Aggressi
USA 3 GenericErosion Aggressi
USA 4 GenericErosion Aggressi
USA 1 GenericErosion Moderate
USA 2 GenericErosion Moderate
USA 3 GenericErosion Moderate
USA 4 GenericErosion Moderate