Re: Separate PK in Jxn Tbl?

From: Bob Badour <>
Date: Thu, 31 Jan 2008 10:20:14 -0400
Message-ID: <47a1d91e$0$4068$>

Salad wrote:

> 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 prefer KISS.

Well, the second S is right.

> Thus I prefer an autonumber.

So, adding a useless third column makes it simpler?!?

> Then again, junction tables are rarely needed.

That's a remarkable statement requiring extraordinary evidence. What evidence do you have to support such an assertion? Received on Thu Jan 31 2008 - 15:20:14 CET

Original text of this message