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: Another view on analysis and ER

Re: Another view on analysis and ER

From: Jon Heggland <jon.heggland_at_ntnu.no>
Date: Thu, 06 Dec 2007 15:20:33 +0100
Message-ID: <fj90g7$div$2@orkan.itea.ntnu.no> 





Quoth Jon Heggland:


> Granted, but it will be explicit which key a foreign key refers to (or

> it will be implicitly given by the attribute names in the foreign key).




Oops, sorry. SQL does indeed use primary key designation, not column
names, if you're not explicit. But SQL is well-known for mixing logical
and physical concerns. Anyway, I don't think this is a good enough
reason to say that key primacy is a logical issue.

-- 
Jon


Received on Thu Dec 06 2007 - 08:20:33 CST












Original text of this message













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