For Duane Hookom

I have downloaded your excellent survey database.

I am building a survey database from scratch and am still in the planning on
paper stage.

My tables are as follows:

tbl_questionnaires
qstnaire_id (PK)
qstnaire_name
qstnaire_code
qstnaire_description

tbl_participants
ppt_id (PK)
ppt_no
ppt_given_name
ppt_family_name
ppt_id_no
ppt_date_of_birth
ppt_gender
pregnant
rltnshp_to_hd_of_hshld
ppt_house_no
ppt_phone_no

tbl_questions
question_id (PK)
qstnaire_code (FK)
question_number
question_text

tbl_answers
answer_id
answer_no
question_id (FK)
answer

tbl_responses
response_id (PK)
question_id (FK)
answer_id (FK)
participant_id (FK)
qstnaire_date
qstnaire_start_time

tbl_interviewers
interviewer_id (PK)
interviewer_no
Interviewer_given_name
Interviewer_family_name

tbl_household_relationships
hshld_relationship_id (PK)
hshld_relationship_category (FK)
hshld_relationship_no
hshld_relationship_description

The questions are made up of the qstnaire_code field and 1, 2, 3, etc.
There are no sub questions.

While many questions limit the answer to one listed, some require text
reponse from the individual being interviewed.

The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 -
female on one question and 1 - Yes, 2 - No on another, etc. There are two or
three numbers that may appear that are always the same: 50 - NR and 51 -
Don't know. These answers are always numbered 50 and 51, even if they follow
answers 1, 2, 3, 4 (50, 51).

My questions, at the moment are:

1. Does my structure, so far, look sound?
2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I
would hav thought they would be in the Reponses table.
3. I assume that I will need a record for each and every response to each
and every question.
4. I have headings at the beginning of sets of questions with the various
questionnaires - Section 1 "xxx", followed by questions pertaining to that
section, etc. Would I include that as a level in my tblQuestions?

Any guidance would be GREATLY appreciated!

Thank you so much!


--
Thanks!

Dee
.

Loading