Re: Another view on analysis and ER

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Thu, 06 Dec 2007 12:41:13 -0400
Message-ID: <4758262a$0$5303$9a566e8b@news.aliant.net>

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 - 10:41:13 CST