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>

[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