Re: Question on Primary Keys
From: Jan Lenders <J.Lenders_at_Betuwe.net>
Date: Mon, 16 Oct 2000 07:01:07 GMT
Message-ID: <8se93i$qm3$1_at_nnrp1.deja.com>
Date: Mon, 16 Oct 2000 07:01:07 GMT
Message-ID: <8se93i$qm3$1_at_nnrp1.deja.com>
> Each USER belongs to an ORG_UNIT.
Sent via Deja.com http://www.deja.com/
> (a) The USER table can have a combined PK of USER_ID & ORG_UNIT_ID
> (b) The USER table can have a PK of USER_ID (some sort of unique
> number) and have ORG_UNIT_ID as a FK.
>
Raju,
If the existence of a USER object is dependent on the existence of a
ORG_UNIT you should make the ORG_UNIT_ID (foreign key) a primary key in
the USER table.
Before you buy.
Received on Mon Oct 16 2000 - 09:01:07 CEST