problem with m:n relationship

2009-02-03 Thread Stephen Winnall
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

Re: How to create Meaningful Primary Keys? JUST SAY NO TO MEANINGFUL POINTERS!

2009-02-03 Thread Kevin Menard
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