Re: Which normal form is this violating?
From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 29 Apr 2002 15:35:40 -0700
Message-ID: <c0d87ec0.0204291435.2e5cd35e_at_posting.google.com>
Date: 29 Apr 2002 15:35:40 -0700
Message-ID: <c0d87ec0.0204291435.2e5cd35e_at_posting.google.com>
>> Here's where I lost you, unless you're assuming that Table_B.fieldx
is NOT a foreign key. If it IS a foreign key (and I think it's
reasonable to assume that's how they're thinking about it), then the
above insert fails. <<
>> It seems to me like Table_A defines the domain of fieldx values,
and Table_B actually uses those values. <<