table design

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
 
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.
 
Thank you so much Duane about your opinion...

Duane Hookom said:
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.
Click to expand...
 
Back
Top