I have many rows of shipping prices up to a variety of weights under different zones and services.
For each zone and service there is also an additional row which adds on a price for every additional chunk of weight beyond the maximum.
Now I could just put in a boolean that separates the functionality of the rows but I wasnt fond of this idea because the additional weights are very few in number and would be used very rarely. So there would be an additional bit of data for every row in the table rarely doing anything.
The alternative would be to separate those functions out in to two identical tables, I have had a look at orthogonal database design but find it difficult to work out if this would violate it. I dont think it does because they differ in function enough to stop 'overlapping meaning'.
So I am unsure which to go with and have come to ask which would be the better choice if there is one?