Tags: access, brief, database, design, designed, entry, hii, microsoft, mysql, oracle, questionnaire, sql, storage

questionnaire database design

On Database » Microsoft Access

1,546 words with 4 Comments; publish: Wed, 12 Dec 2007 10:28:00 GMT; (25078.13, « »)

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

thanks

All Comments

Leave a comment...

  • 4 Comments
    • probably best to ask this in the Access forum.. so Ill move it there
      #1; Tue, 11 Dec 2007 21:07:00 GMT
    • Have a look at Rudy's (R937) (http://www.r937.com/relational.html) site
      #2; Tue, 11 Dec 2007 21:08:00 GMT
    • Here's a tutorial on designing an Access survey database:

      http://www.functionx.com/access/applications/survey.htm

      #3; Tue, 11 Dec 2007 21:09:00 GMT
    • The one thing I can tell you about a survey database (and I've designed quite a few) is try to avoid hardcoding the question into the fieldname! Questions will undoubtly change. I had a lookup table (1 field) which held the questions and a data table which populated a field with the question sentence and another field for the answer.
      #4; Tue, 11 Dec 2007 21:10:00 GMT