April 6, 2005 at 3:13 am
I need some help designing some addtional tables to go into my e-commerce database.
I need to add the following information:
Courier name
Shipping method
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?
April 7, 2005 at 12:34 pm
If you have a little cash,time ad aptitude, try a data modeling tool like ErWin ... if you're lacking in any of the first three and you need very good availability and have high transaction volumes then maybe a consultant is the way to go.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
April 8, 2005 at 7:55 am
I tend to agree with Rudy on this. If you are not sure of the 'normalization' rules and how to do it, you should have an external party look at it.
Hgh availablity and fast throughput does not ALWAYS mean normalization. That's always a starting point, but the 'art' of it is being able to denormalize appropriately for performance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply