Re: database's table design with similar foreign keys

Jim Gross <jmgross_at_worldnet.att.net> wrote:

[snip]

>Finally, if none of the above workarounds appeal to you, go with the simpler
>solution and populate the duplicates and same-city records. You probably
>wouldn't notice any difference in performance and I'm sure the redundancy
>won't use up that much additional disk space.

     It will *double* it (assuming no same-city records).

>Good luck.

[snipped previous]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.