Re: Relation problem
Date: Tue, 30 Jan 2001 17:16:42 GMT
Message-ID: <3a76f699.6822319_at_news.compuserve.com>
On Mon, 29 Jan 2001 18:16:44 GMT, "Michel" <microworld_at_sympatico.ca> wrote:
>Are you saying to group the Org table and Ind table into the new party
>table? If that is so, then that cannot be done, since they are in excess of
>35 relations on the ind table and over 15 relations on the Org table and the
>tuples of each are completely different.
No. I'm saying that you can put the few attributes common to individuals and organizations into a single, new table (which I usually name "Parties"). Then you can use the primary key from Parties in your table of party addresses.
Individuals and organizations have three attributes in common (probably). They all have some kind of ID number (probably), they all have a name, and they all have a "type". In the little schema I posted, individuals are of type "Ind", and organizations are of type "Org".
-- Mike Sherrill Information Management SystemsReceived on Tue Jan 30 2001 - 18:16:42 CET