Re: Separate PK in Jxn Tbl?
From: James A. Fortune <MPAPoster_at_FortuneJames.com>
Date: Thu, 31 Jan 2008 15:00:22 -0500
Message-ID: <eU$f6QEZIHA.5984_at_TK2MSFTNGP06.phx.gbl>
>
>
> Shouldn't a database be designed right from the beginning?
>
Date: Thu, 31 Jan 2008 15:00:22 -0500
Message-ID: <eU$f6QEZIHA.5984_at_TK2MSFTNGP06.phx.gbl>
Sylvain Lafontaine wrote:
>>I concede the point that for the two keys of the junction table, using an >>autonumber primary key is overkill except for special situations.
>
>
> Shouldn't a database be designed right from the beginning?
>
I didn't say overkill doesn't work, did I :-)? I think that until we delineate the true trade-offs between natural keys and artificial keys, if any, you should design your schemas/schemata as you deem best. If it turns out that there are situations where each has advantages then those situations should determine the correctness of the schema.
James A. Fortune
MPAPoster_at_FortuneJames.com
Received on Thu Jan 31 2008 - 21:00:22 CET