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@nnrp1.deja.com>

> Each USER belongs to an ORG_UNIT.
> (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.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 16 2000 - 02:01:07 CDT