J
Jim C
Hello All,
I'm trying to design an Exit Interview database for my company (we're a
fairly small company, ~220 people), and was wondering if someone could
review the table design that I've prepared below.
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.php?t=1081046&highlight=survey+database
http://www.databaseanswers.org/data_models/questionnaire_complex/index.htm
http://www.databaseanswers.org/data_models/index.htm
http://groups.google.com/group/comp...rdwick++questionnaire&rnum=7#a7283bbcf20a5189
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_hrid
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_supervisors
suprvsr_hrid
suprvsr_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)
Because I have three different types of answers (yes/no, text, and
likert-type scales), 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. Thanks for your help!
I'm trying to design an Exit Interview database for my company (we're a
fairly small company, ~220 people), and was wondering if someone could
review the table design that I've prepared below.
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.php?t=1081046&highlight=survey+database
http://www.databaseanswers.org/data_models/questionnaire_complex/index.htm
http://www.databaseanswers.org/data_models/index.htm
http://groups.google.com/group/comp...rdwick++questionnaire&rnum=7#a7283bbcf20a5189
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_hrid
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_supervisors
suprvsr_hrid
suprvsr_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)
Because I have three different types of answers (yes/no, text, and
likert-type scales), 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. Thanks for your help!