Re: Does entity integrity imply entity identity?
Date: Sun, 2 Aug 2009 09:16:22 +0100
"Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message
> Mr. Scott wrote:
>> "Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message
>>>Mr. Scott wrote:
>>>>Since the entity integrity rule ensures that a relational table cannot
>>>>have any duplicate rows, does that imply that each row in a table maps
>>>>to a distinct entity?
>>>I am unfamiliar with an entity integrity rule. It sounds like some shit
>>>somone just made up to market ER diagrams.
>> I thought Codd referred to the the entity integrity and referential
>> integrity rules as the insert-update-delete rules of the relational
> Can you cite a reference for that?
It therefore originates from the point at which Codd decided to "extend" the model with E-relations, nulls and other exotic things. The rule begs more questions than it answers (what about derived relations and relations with multiple keys?). Myself and likeminded people are happy with the concept of a pre-RM/T relation that needs no such rules.
-- David PortasReceived on Sun Aug 02 2009 - 10:16:22 CEST