Re: Foreign key problem
Date: 14 Jun 2006 01:18:15 -0700
> At the end of the day, foreign keys is an implementation issue. But Ted
> Codd had a lot to say about the domain of foreign keys. The "glue".
Foreign keys (or better : the referential integrity rules that embody FKs) are an implementation issue to those writing DBMS's. They are very much a model issue to those writing applications that use a DBMS.
Date and Darwen still have a lot to say about foreign keys, and since that is based on over thirty years of additional research and the corresponding increased insights in the matter, their writings are now far more relevant than are Codd's. Incidentally : they have absolutely *nothing* to say about *the domain* of foreign keys, because they have nothing to say about the domain of attributes in general. Received on Wed Jun 14 2006 - 10:18:15 CEST