Re: FK -> non PK - bad design?
From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 12 Apr 2003 17:24:54 -0700
Message-ID: <c0d87ec0.0304121624.3960053a_at_posting.google.com>
Date: 12 Apr 2003 17:24:54 -0700
Message-ID: <c0d87ec0.0304121624.3960053a_at_posting.google.com>
>> Bernard, seems to me that just the fact that users may want to
change
the name of a service plan is reason enough for a system generated
ID/PK. <
Look up how to use ON UPDATE CASCADE clauses in your DRI. This lets the system handle all of that stuff automatically, so it is faster, safer and the scheam is portable without the application code that was updating the service plans. Received on Sun Apr 13 2003 - 02:24:54 CEST