I need some help designing some addtional tables to go into my e-commerce database.
I need to add the following information:
Courier's worldwide postage rates by weight bands.
I already have a comprehensive country list in tblCountry
But what is the best method to use (lookup tables etc) to get this postage rate info into the dbase?
I imagine a table for Couriers,
1 for CourierDestinations (containing CourierID & CountryID),
1 for Weightbands containing generic lower and upper boundaries of weight bands,
and 1 for ShippingRates containing CourierDestinationID, WeightID and rate.
However, as I am keen to keep this database as normalized as I can, I'm not sure the best way to implement this.
Can anyone advise?