Re: Table design problem

From: Mike Sherrill <MSherrill_at_compuserve.com>
Date: Tue, 08 Apr 2003 00:24:38 -0400
Message-ID: <oka39vkqh45kago16ttprditom7bt1181i@4ax.com>

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

Received on Mon Apr 07 2003 - 23:24:38 CDT