Re: the two questions

From: Bob Badour <>
Date: Sun, 25 Nov 2007 14:29:33 -0400
Message-ID: <4749bf12$0$5303$>

David Cressey wrote:

> "Brian Selzer" <> wrote in message
> news:Dj92j.77429$

>>"JOG" <> wrote in message
>>>On Nov 24, 12:38 am, vldm10 <> wrote:
>>>>Not long time ago on this NG there were few posts which involved an
>>>>entity with 200+ attributes.
>>>>Let all these attributes satisfy the following two conditions:
>>>>1) All these attributes are mutually independent
>>>Then there are no functional dependencies so the entity can only be
>>>identified by the collection of all its attributes - and hence you'd
>>>end up with an equivalent superkey. If any of those attributes
>>>"change" it would also therefore be a different entity altogether.
>>It cannot be determined whether two representations from two distinct

> points
>>in time refer to the same individual--even if all of the attribute values
>>are identical--unless, of course, one of the attributes is a surrogate;

> Do you mean "surrogate" or "synthetic" ?

Actually, what he is saying is at least one attribute must remain the same. Whether that attribute is a surrogate is a red herring.

Suppose two tuples differ completely except for one attribute you know was assigned arbitrarily. How do you know they are really the same thing? After all, all observable properties have changed. The fact that an arbitrary number is the same doesn't really tell us much. Received on Sun Nov 25 2007 - 19:29:33 CET

Original text of this message