Le_Forgeron wrote:
> Le 06/08/2009 23:05, Darren New nous fit lire :
>> Mike Raiford wrote:
>>> That's right, a row for every city, and a row for every state.
>> Sounds very Enterprise to me.  Helpful if you want to assign salesmen to
>> regions and stuff like that.
>>
> Sounds also a good schema: no repetition of long shareable data.
> May be a bit too optimised.
> 
> And easier update next time south-dakota decides to have a new name too.
> New-Orleans... nah... call us Atlantide from now on!

More importantly, it helps keep you from accidentally spelling the name 
wrong during data entry (or lets you provide a drop-down list or whatever), 
thereby ensuring data consistency.

-- 
   Darren New, San Diego CA, USA (PST)
   "We'd like you to back-port all the changes in 2.0
    back to version 1.0."
   "We've done that already. We call it 2.0."

Post a reply to this message