Post reply

Database design issue.

  • March 20, 2007 at 6:51 am

    #171796

    Hi All,

    I am struggling to find the good design for a requirement which states that in an insurance organization the claimant could be a person or an organization, both constitute an entity and an entity can have an attorney, an insurance policy, etc. I came up with two designs but am pleased with neither. design one, a Claim table ClaimId as pk, person table personId as pk and an Organization table Orgid as pk. design two, a claim table, an entity table. The messy part is to have a table with personid and Orgid or an entity table with an entity type field. Any suggestions? (the demographics of a person and an Organization are different)

    Thanks

    CRM

  • March 20, 2007 at 1:50 pm

    #696032

    I am not sure if your last option is relational but there are sample data models in the link below including three for the insurance industry.  Hope this helps

    http://www.databaseanswers.org/data_models/index.htm

     

    Kind regards,
    Gift Peddie

  • March 20, 2007 at 3:54 pm

    #696059

    Hi Gift Peddie,

    Thanks a lot, thats a cool site.

    Regards

    CRM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply