table design

[Guest]

I created a survey table in database...But my question is how can you create
tables and name columns for a survey, if you were me??Are these enough column
names??Or should it be more?


SURVEY_HEADER
---------------------------

CENTER_ID

CENTER_RESPONSIBLE

CENTER_RESPONSIBLE_TITLE

CENTER_RES_RESPONSIBILITY

UNIQUE_ID



QUESTIONS
-----------------

UNIQUE_ID

QUESTION_ID

QUESTION



ANSWERS
-----------------

UNIQUE_ID

QUESTION_ID

ANSWER



INVENTORY
----------------

UNIQUE_ID

INVENTORY_ID

INVENTORY

ANSWER_ID



SURVEY_DETAIL
----------------

UNIQUE_ID

CENTER_ID

ANSWER_ID

ANSWER

 

[Jeff Boyce]

If you'd like a point of comparison,

Duane Hookom has a sample survey database at
http://rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Guest]

Thank you so much Jeff, but i havent got Access in my pc...so i cant see the
tables and columns...im at work now...do u have an opinion about my survey
table?

 

[Duane Hookom]

I think you seem to be on the proper track with your table designs. It looks
fairly normalized which is great. The link supplied by Jeff has similar
structures with a full implementation including forms for creating surveys,
entering results, and creating reports.

 

[Guest]

Thank you so much Duane about your opinion...

I think you seem to be on the proper track with your table designs. It looks
fairly normalized which is great. The link supplied by Jeff has similar
structures with a full implementation including forms for creating surveys,
entering results, and creating reports.