I am creating a database for donor management. Donors represent two subgroups: individuals and organizations. It appears the only fields shared by both groups are as follows.

Donors
donor_id (PK)
donor_type_code (FK)
donor_status_code (FK)

This is a simplified example, but basically for an individual, I need to keep track of the following fields.

first_name
last_name
home_address
company_name
company_address
other_details
spouse_first_name
spouse_last_name
spouse_other_details

For an organization, I need to keep up with primary and alternate contact information. A primary contact will be required to set up the organization, but alternate contact is optional.

organization_name
prime_contact_first_name
prime_contact_last_name
prime_contact_address
prime_contact_other_details
alt_contact_first_name
alt_contact_last_name
alt_contact_address
alt_contact_other_details

Do individuals and organizations represent subordinate subjects of donors? The address fields seem to be duplicated for an individual, and again for primary contact and alternate contact. Any advice on the proper way to address this is greatly appreciated.

RDCD

You may create a name object(f,m,l,s) , an address object, a person type lookup, a address type lookup( basically an address owner)
and join with donors.
-A.

Thanks for your reply. I think I follow most of your explanation. Can you point me to an example of a data model where multiple customer types (donors in my case) and their attributes are joined?

RDCD

name object(f,m,l,s) , an address object are oracle objects not tables

and I thought donor was a dependent entity.

-A.