Is CAY-1009 (Bogus runtime relationships can mess up commit) due for
resolution any time soon? I think I've run into it whilst modelling an
m:n relationship. The work-around (making the attributes in the
intersect entity non-mandatory) works, but it would be nice to do it
properly.
Steve
Yes. The problem is between best practice and best theory. I'd still
normalize based on functional dependencies, but add in the surrogate
key and then just add a unique index on the functional key.
--
Kevin
On Mon, Feb 2, 2009 at 5:09 PM, Malcolm Edgar wrote:
> I think what we are talking a