Questionnaire Database design

mahauhau's Avatar, Join Date: Jun 2007
Newbie Member
Hi
I have designed a small questionnaire and i want to use Ms Access for data entry and storage.
Here is the brief description.
------------------
A.Heading
------------------
1.Person id
2.date of birth
3.age
4.sex
5.school
-----------------------
B.Sports Information about individual
------------------------------
1.do you play any spot ------yes/no
2.what spot do you play -----1.football 2.tennis 3.other
3.is your father still alive-----yes /no
4.what spot does he play------1.football 2.tennis 3.other
5.at what age did you start school
6.what is your political affiliation 1.liberal 2.centre . other

-----------------------------------------------
C.For official use only
---------------------------------------------
1.Date of interview-------
2.How enthusiastic was the respondent----1.very 2.Average 3. Below average

How can i go about designing a relational database for the above questionnaire.
I need advice on the relational schema

I will appreciate a link to a site where Questionnaire Database design is discussed
thanks
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
The plain and simple design could be all in one table. All is related to the user.
0
mahauhau's Avatar, Join Date: Jun 2007
Newbie Member
Thanks
Actually all my thinking led to one table.
I just thought there could be another way to do it.
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
The one table is the best solution for your requirements.