Re: storing survey answers of different data types
From: <cimode_at_hotmail.com>
Date: Fri, 24 Apr 2009 01:59:53 -0700 (PDT)
Message-ID: <a3d79cec-94d5-449b-b1ac-c840ff1e0c77_at_37g2000yqp.googlegroups.com>
Date: Fri, 24 Apr 2009 01:59:53 -0700 (PDT)
Message-ID: <a3d79cec-94d5-449b-b1ac-c840ff1e0c77_at_37g2000yqp.googlegroups.com>
[Snipped]
> > You just swallowed the red pill in Matrix... > > Oh, is that why I'm standing in a sewer, covered in goo? :)For what it's worth, here is an application specific design to help you...Thanks to heavy M:N cardinalities , it opens up some possibilities for adaptation to the full spectrum of your requirement...
question:
questionid text 1 What is your Pet's Name ? 2 Where do you spend your hollidays ? 3 What is the color of your car ? 4 What is the color of your shirt ?
answer
answerid text 1 Snoopy 2 Droopy 3 Sam 4 Cancun 5 France 6 Black 7 Brow 8 White
survey
testid startdate enddate theme 1 01/02/2008 01/03/2008 February testing campaign1 2 01/03/2008 01/04/2008 March testing campaign2 3 01/02/2008 02/04/2008 Testing campaign3
question_answer_survey
questionid answerid testid 1 1 1 1 2 1 1 3 1 2 4 1 2 5 1 1 1 2 1 2 2 1 3 2 2 4 2 2 5 2 3 6 2 3 7 2 3 8 2 4 6 2 4 7 2 4 8 2
candidate
candidateid lname fname DOB 1 Doe John 12/10/1968 2 Parkins Bryan 09/02/1954 3 Jordan Michael 01/02/1967
results
testid candidateid questionid answerid 1 1 1 3 1 2 1 2 1 1 2 4 1 2 2 5 2 1 1 3 2 2 1 2 2 1 2 4 2 2 2 5 and so forth....................................................
Hope this helps... Received on Fri Apr 24 2009 - 10:59:53 CEST