[AccessD] Slow day - normalization discusion

Have to remember too, that some countries, like China, use a 3 digit prefix 
and a 5 number line (668-57175). Then there are those pesky country and city 
codes....

Don B.

----- Original Message ----- 
From: "Susan Harkins" <ssharkins at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, June 18, 2008 9:53 AM
Subject: Re: [AccessD] Slow day - normalization discusion


> Repetition isn't the only thing to consider:
>
> 1.) Smallest unit -- we think of those 7 digits as its own value. 
> Therefore,
> as a whole, the 7 digits aren't repeated, but some numbers have the same
> first 3 digits in common. You can find that commonality in all kinds of
> values. So, when you look at the digits as a whole, they aren't truly
> repeated values.
>
> 2.) Data entry -- consider how much work will be necessary to put those 
> two
> values back together to faciliate data entry. Normalization aside, human
> beings aren't use to entering 3 digits and then 4 -- it will only confuse
> people and slow down data entry.
>
> Susan H.
>
>
>
>> If the numbers in the database are not clustered in the areas, having the
>> same prefix codes, it won't make sense to pull the prefixes out. I don't
>> know
>> the exact mechanics of why, but I wouldn't separate data into another
>> table
>> unless the new table was going to contain significantly fewer rows than
>> the
>> original. You also have to account for how much this will speed up
>> searches
>> etc. versus the burden of performing the join slowing updates etc.
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com