Results 1 to 1 of 1
  1. #1
    Join Date
    May 2006
    Posts
    2

    Unanswered: Help with table design for survey database

    Hello All,

    I'm trying to design an employee Exit Interview database in Microsoft Access 2003, and was wondering if someone could review the table design that I'm trying to put together.

    The gist of the problem is that I have three different types of answers (yes/no, text, and likert-type scales . . . eg excellent, good, fair, poor . . . i know that these are essentially multiple yes/no data type reponses . . . ), I'm not sure if I'm handling the answer types and table designs correctly. Does anyone have any suggestions? I have looked at the "At Your Survey" database that was created by an Access MVP, but want to actually create my own application as a learning process.

    As a reference, I've reviewed a number of postings about survey database designs, including the threads and info found in the following
    links:

    http://www.dbforums.com/showthread.p...ght=survey+dat
    http://www.databaseanswers.org/data_...plex/index.htm
    http://www.databaseanswers.org/data_models/index.htm
    http://groups.google.com/group/comp....5bd716d4fb08c7

    I've also put a basic outline of the table design that I've come up
    with in an excel spreadsheet, and it's available here:
    http://www.j1m.net/lj/db/draft_of_table_design.xls , but if you won't want to download the file, here is what I've come up with so far:

    (**the beginning stuff is pretty basic . . . **)

    tbl_staff_info
    auto_number
    hrid (the employee's ID number)
    f_name
    l_name
    dept_id
    jobtitle_id
    location_id
    suprvsr_name (I know that it would be better to just have a field like supervisor_hrid link to a supervisor table, but it is more trouble than it is worth in this case.)
    hire_date
    term_date
    last_perf_rating_id

    tbl_depts
    dept_id
    dept_name

    tbl_job_title
    job_title_id
    job_title

    tbl_locations
    location_id
    location_name

    tbl_perf_ratings
    last_perf_rating_id
    perf_rating

    (**end of the really basic stuff**)

    tbl_questions
    question_id
    question_type
    question_text

    tbl_answers
    answer_id
    hrid
    question_id
    answer (note: yes/no data type)

    tbl_other_answers
    other_answer_id
    hrid
    question_id
    other_answer (note: text data type - 255 char limit)

    tbl_boolean_answers
    boolean_answer_id
    hrid
    question_id
    boolean_answer (e.g. excellent, good, fair, poor)

    Do I have the answer tables set up logically? If so, will I need a lot of code to make those three answer tables work correctly? Thanks so much for your help!!
    Last edited by j1mc; 05-31-06 at 17:18.

Posting Permissions

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