Unanswered: Help with table design for survey database
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
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 . . . **)
hrid (the employee's ID number)
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.)