Re: Another view on analysis and ER

From: Bob Badour <>
Date: Thu, 06 Dec 2007 12:41:13 -0400
Message-ID: <4758262a$0$5303$>

Jon Heggland wrote:

> Quoth Bob Badour:

>>Keys and references are logical issues and not physical issues. Physical
>>issues affect only performance.

> Keys are, but key /primacy/ is not. If one ignores any performance
> differences between a primary key and any other key (as of course one
> should, although it may not be possible in current SQL systems), the
> remaining difference is merely syntactical convenience---hardly a
> logical issue.

That's an interesting take on it. While it is a syntactical shorthand, it is a shorthand for a logical consideration. Received on Thu Dec 06 2007 - 17:41:13 CET

Original text of this message