1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Questionnaire Database design

Discussion in 'Database' started by mahauhau, Jun 26, 2007.

  1. mahauhau

    mahauhau New Member

    Joined:
    Jun 26, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    The plain and simple design could be all in one table. All is related to the user.
     
  3. mahauhau

    mahauhau New Member

    Joined:
    Jun 26, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Thanks
    Actually all my thinking led to one table.
    I just thought there could be another way to do it.
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    The one table is the best solution for your requirements.
     

Share This Page