My client conducts a number of surveys or questionnaires for THEIR
clients. There are several standard surveys, each with a different
number of questions (from 20 up to 90).
Question is, how store the data.
Seems like the simple way would be to create a table with 100 fields
and store the answers (plus metadata - survey #, timestamp, etc)
there, each record using up as many fields as necessary. In this
case I'd probably store the metadata in fields 1-10 (as needed) and
begin the real data in field 11.
Or could use one table per survey type - so that only data from the
same list of questions goes into each table.
Or could use a simpler table that stores only one answer per record
(with a couple fields for metadata and one for the answer). Frankly
dissociating the data so much scares me a bit, but this would seem to
be the logical best choice - assuming nothing to go wrong.
Any thoughts, warning, experiences on this matter. - And in a related
question, what is the best form in which to EXTRACT the data for
running into a desktop graphing program? Write to a file in a public
directory?
Thanks for any help,
Nelson
--
===========================================================
Nelson Goforth Lighting for Moving Pictures
phone: 01.303.322.5042 pager: 01.303.634.9733
resume: http://www.earthnet.net/~ngoforth/film
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php