Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2010
    Posts
    4

    database design advice: 30 questionnaires x 4 timepoints

    hi all,

    i would really appreciate any input on how to go about designing a database based on a longitudinal survey.

    Basically i have at least 30 questionnaire that is being administered to over 100 participants, at 4 different time points (same participants). Each questionnaire has at least 10 questions, some are "Yes" or "No", some are multiple-choice single selection, multiple-choice multiple selection, and open comments.

    these data will later be tranferred to SPSS or SAS. But in the mean time I need to manage the data to generate reports for regular meetings and updates.

    can anyone give any insights on the design?

    also can anyone recommend a database software that allows export of variable labels and value labels (i.e. 1=Male, 2=Female, etc.)?

    thanks!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    any database software should be able to support 'variable labels' through a query
    however why not store your data in a more meaningful way
    eg
    M:Male
    F:Female
    I:Indeterminate
    ?:unknown, possibly transgender

    as regards the storage if data
    I'd suggest you breakdown your functional requirement according the principles of realtional db design
    Fundamentals of Relational Database Design -- r937.com
    and / or
    The Relational Data Model, Normalisation and effective Database Design
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You could consider something like surveymonkey. For such a small requirement I would be very hesitant building something from scratch.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Oct 2010
    Posts
    4
    That is a good point. However, we want the data to be ready for statistical analysis, thus the numeric assignments.

    Quote Originally Posted by healdem View Post
    any database software should be able to support 'variable labels' through a query
    however why not store your data in a more meaningful way
    eg
    M:Male
    F:Female
    I:Indeterminate
    ?:unknown, possibly transgender

    as regards the storage if data
    I'd suggest you breakdown your functional requirement according the principles of realtional db design
    Fundamentals of Relational Database Design -- r937.com
    and / or
    The Relational Data Model, Normalisation and effective Database Design

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •