Re: Another view on analysis and ER
Date: Thu, 06 Dec 2007 15:20:33 +0100
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.
-- JonReceived on Thu Dec 06 2007 - 15:20:33 CET