Re: Separate PK in Jxn Tbl?
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Thu, 31 Jan 2008 10:20:14 -0400
Message-ID: <47a1d91e$0$4068$9a566e8b_at_news.aliant.net>
> I prefer KISS.
Date: Thu, 31 Jan 2008 10:20:14 -0400
Message-ID: <47a1d91e$0$4068$9a566e8b_at_news.aliant.net>
Salad 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.
> 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