>> 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.
Agree. Regardless of being a surrogate or not, keys provide logical identity
and it makes little sense to talk about any kind of constraints without
them.
--
Anith
Received on Mon Feb 27 2006 - 11:25:55 CST
