Re: Many to Many Relationships

From: Custom Key <cqhy_at_hotmail.com>
Date: Wed, 12 Dec 2001 03:47:06 +0000 (UTC)
Message-ID: <ed9ec7118e22ef3498f414d0ae960253.44906@mygate.mailgate.org>

"Bernard Peek" <bap_at_shrdlu.com> wrote in message news:txXanoHrARD8EwG6_at_shrdlu.com...

> In message <20011203224457.11238.00001101_at_mb-fi.aol.com>, Adam Steiner
> <ajsteiner_at_aol.comnospam> writes
> >Hello,
> >

...clip...
>
> You are assuming several things. First, that there are only three roles
> that a lawyer can take in a case. Second, that each role requires one
> and only one lawyer. If both of those assumptions are known to be true
> in every case then your design is fine. If there are ever any exceptions
> then you have a problem.
>

I second this motion. Further ... the column(s) for lawyer(s) in the case table can be eliminated.

-- 
Posted from  [204.119.252.66] 
via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Tue Dec 11 2001 - 21:47:06 CST