Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Key attributes with list values was Re: What are the differences ...KEY

Re: Key attributes with list values was Re: What are the differences ...KEY

From: Marshall Spight <marshall.spight_at_gmail.com>
Date: 27 Feb 2006 09:03:24 -0800
Message-ID: <1141059804.032864.75670@e56g2000cwe.googlegroups.com> 





Anith Sen wrote:

>




> With those propositions, how do you make sure that the DBMS is aware of the

> fact that Jane Harper and Jane Smith are the same entity?




With those propositions, you can't, of course. Declaring name as the
key is declaring that two people with the same name *are* the same
person. Or perhaps more accurately, a table with person-names
as the key is a table of names, not a table of people. Since names
can't have a marital status, trying to map the table's attributes
back to the real world breaks down.




Marshall
Received on Mon Feb 27 2006 - 11:03:24 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US