Re: Relation problem
From: <MSherrill_at_compuserve.com>
Date: Thu, 18 Jan 2001 20:03:07 GMT
Message-ID: <3a672d47.8828885_at_news.compuserve.com>
Date: Thu, 18 Jan 2001 20:03:07 GMT
Message-ID: <3a672d47.8828885_at_news.compuserve.com>
On Thu, 18 Jan 2001 01:46:24 GMT, "Michel" <microworld_at_sympatico.ca>
wrote:
>Designing this large database where we store adresses as their own entity.
Use a table of parties instead.
Parties
>i.e. an address exist by itself.
>We also have individuals AND organizations that can have have more than 1
>address. So far so good, created a link table were I wanted to use the
>primary key as individualID and AddressID.
>
>This would be great, but it's got to be an individual OR an organization, so
>I cant have referencial integrity enforced at the database level.
--
PartyFullName (Like you'd find in the phone book or a Rolodex.)
KindOfParty ("Individual", "Organization")
-- Mike Sherrill Information Management SystemsReceived on Thu Jan 18 2001 - 21:03:07 CET