Re: Table design problem

On Mon, 31 Mar 2003 10:42:39 +0000 (UTC), "Roy Hann" <rhann_at_globalnet.co.uk> wrote:

>I think I want to create a couple of subtype entities in an SQL database.
>In this database customers may be either of two subtypes: Individuals or
>Corporations.

If individuals and corporations are really subtypes, then you should be looking at the supertype.

Let's say the supertype "Parties" consists of the subtypes "Individuals" and "Organizations". Since both individuals and organizations can be customers, you'd associate customers with the supertype "Parties".

-- 
Mike Sherrill
Information Management Systems