Re: What are the design criteria for primary keys?

On Mon, 06 Sep 2010 19:56:38 -0300, Bob Badour <bbadour_at_pei.sympatico.ca> wrote:

>Gene Wirchenko wrote:
>
>> On Fri, 03 Sep 2010 23:28:04 -0300, Bob Badour
>> <bbadour_at_pei.sympatico.ca> wrote:
>>
>> [snip]
>>
>>>Try living with an address that has a street #, a phase # and a suite #.
>>>I cannot count how many idiotic programmers wrote code that threw away
>>>key parts of my address when I had one like that.
>>
>> What is a "phase #", please? A quick Web search got me nothing.
>
>Imagine 2 or 3 towers in a condominium development. Phase 1 gets built
>first, Phase 2 gets built second and the developer abandons Phase 3
>before it's finished because the real estate market went soft.
>
>Now, imagine they are joined at the base with a single entrance and a
>single street number.

     Ah. I have never seen that. I have seen buildings in a complex, but I do not think with the same address for two buildings.

Sincerely,

Gene Wirchenko Received on Tue Sep 07 2010 - 02:12:14 CEST