Re: Database Design Question

From: Ja Lar <ingen_at_mail.her>
Date: Mon, 6 Dec 2004 21:06:24 +0100
Message-ID: <41b4bc19$0$223$edfadb0f@dread11.news.tele.dk>

"Troels Arvin" <troels_at_arvin.dk> skrev i en meddelelse news:pan.2004.12.06.19.04.50.515498_at_arvin.dk...
> On Mon, 06 Dec 2004 18:15:43 +0100, Ja Lar wrote:
>
>> I think it is a bad advice to encode business-meaning in the PK.
>
> In the spirit of your laconic message:
>
> I think it's good advice in this case.

I think it's a bad advice in any case. Why not - in this case - at least use (split to) a composite key, possibly with each column a FK (a code) to a set of values,eg: "color" , "size" etc.?
The need for a CHECK on a representation-determined format on a single column key seems cautionary. Received on Mon Dec 06 2004 - 14:06:24 CST

Re: Database Design Question - any suggestion?