On 8 jul, 18:48, DA Morgan <damor..._at_psoug.org> wrote:
>
> Perhaps from a more realistic standpoint the relationship must be M:M
> as one manufacturer may have more than one item and an item may have
> more than one manufacturer.
>
> The solution is use deferrable constraints, an intersecting entity, and
> perform the enforcement of the business rule with the primary key of the
> intersection.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
True, but not what the OP stated.
What you describe is the, let's say, natural way things are?
Received on Mon Jul 09 2007 - 04:49:36 CDT
