Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    1

    Unanswered: Database design for health insurance

    Hi Gurus,

    This is the first time I am dealing with the designing of health insurance database tables, so please help me

    Requirement is as below:

    Enter health insurance information on insurance screen
    User able to select 1 or more insurances at a time
    There are 2 insurance on screen
    1. COBRA
    2. MEDICARE
    MEDICARE subdivided in 4 insurance, Part A, Part B, Part C, Part D
    If user have other insurance than COBRA or MEDICARE, than enter that insurance information

    Would you please suggest me design, how can I design database to meet these requirements?

    I can not think anything as all possible designs I come up, not satisfies all these requirements

    Please suggest design.

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    Looks like homework...

    Show us your designs.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jul 2008
    Posts
    5
    I think you should at least have some core tables, e.g. customer, insurance_plan, policy, user, group, privilege, audit_log, sales......

    You may think about the use cases you'll encounter, how many processes, work flow. Do not try to design your db schema from the UI.

  4. #4
    Join Date
    Jan 2013
    Posts
    1
    Quote Originally Posted by untraceable View Post
    Hi Gurus,

    This is the first time I am dealing with the designing of health insurance database tables, so please help me

    Requirement is as below:

    Enter health insurance information on insurance screen
    User able to select 1 or more insurances at a time
    There are 2 insurance on screen
    1. COBRA
    2. MEDICARE
    MEDICARE subdivided in 4 insurance, Part A, Part B, Part C, Part D
    If user have other insurance than COBRA or MEDICARE, than enter that insurance information

    Would you please suggest me design, how can I design database to meet these requirements?

    I can not think anything as all possible designs I come up, not satisfies all these requirements

    Please suggest design.

    Thanks
    Hi Untraceable, I have a huge project to develop a healthcare insurance database. I was wondering how is your healthcare insurance database development going along? Because I really need some design help. Thx.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    technam99,

    Can you read?
    Please note when this thread started!
    I suggest that you do not hold your breath while waiting for Untraceable to respond.
    While you are waiting for a design to be dropped into your lap, consider researching data normalization & Third Normal Form.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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