Re: circular relationships ok?

From: Marshall Spight <marshall.spight_at_gmail.com>
Date: 2 Mar 2006 15:35:41 -0800
Message-ID: <1141342541.879424.143060@e56g2000cwe.googlegroups.com>

Gene Wirchenko wrote:
> On 2 Mar 2006 14:23:49 -0800, "Marshall Spight"
> <marshall.spight_at_gmail.com> wrote:
>
> >David Portas wrote:
> >>
> >> For example, suppose I want to implement a constraint that each Order
> >> must have exactly one Invoice and each Invoice must have exactly one
> >> Order. That seems like a reasonable business rule, even if it's a
> >> slightly unusual one.
> >
> >If that is the business rule, then are not Invoices and Orders
> >the same entity?
>
> No. (Trying substituting "husband" for "order" and "wife" for
> "invoice".)

Okay. Let me adjust my phrasing:

If that is the business rule, then are not Invoices and Orders the same SQL table?

Marshall Received on Thu Mar 02 2006 - 17:35:41 CST