Results 1 to 4 of 4

Thread: Tables

  1. #1
    Join Date
    Sep 2003
    Posts
    12

    Tables

    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
    Nonprofit Access User

  2. #2
    Join Date
    Oct 2003
    Posts
    17
    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.

  3. #3
    Join Date
    Sep 2003
    Posts
    12

    Tables

    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
    Nonprofit Access User

  4. #4
    Join Date
    Oct 2003
    Posts
    17
    name object(f,m,l,s) , an address object are oracle objects not tables

    and I thought donor was a dependent entity.

    -A.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •