Re: Guru Design Question: Multiple Primary Keys

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David G. (david_nospam_at_nospam.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 19:14:16 -0400

Robert Bouillon wrote:
>
> Why would I not want to use "Real Data" as you put it?
> --ROBERT
>

No reason. It's a perfectly acceptable solution in every way. It's just
that on some highly normalized systems the propagation of keys can get
large once you start moving down the relational heirarchy. It's just
something to watch out for. Also, intelligent keys, if they are used,
sometimes need to change in a production system and if the keys are
propagate, this becomes more difficult to perform. 

-- 
David Gugick
Imceda Software
www.imceda.com