|
![](/i/fill.gif) |
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
|
![](/i/fill.gif) |