Typically, I don't use a generated key if the combination is unique.



LCK



-----Original Message-----
From: Ray Drew [mailto:ray_drew@...]
Sent: Tuesday, December 10, 2002 10:04 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Re: time series and FB/IB



Louis wrote:
#
I use a generated key in a many-to-many situation when there is a
possibility of duplication. If Bob has more that one shirt in his
closet, you might want an entry for each in the Wardrobe table. If you
key on Person and Clothes, this would generate a key violation.
#

Accepted - if person/clothes is not unique it can't be a PK.

What's the argument for a generated key if person/clothes is unique?

Ray

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com





Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=240188.2647639.4038785.2225243/D=egroupweb/S=1705
115386:HM/A=1321406/R=0/*http:/www.e-dealsdaily.com/soundbug/>



<http://us.adserver.yahoo.com/l?M=240188.2647639.4038785.2225243/D=egrou
pmail/S=:HM/A=1321406/rand=439097039>


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]