On Mon, 10 Apr 2006, Brian Menke wrote:
Does anyone happen to know where a basic schema for tracking questions and
answers from tests that a student has completed. I don't know why I am
having difficulty with this, but I can't seem to figure out how to set up
the tables correctly to store this information.
The basics
N number of students
N number of learning modules
Each learning module has multiple questions
Each question has multiple answers.
I need to figure out the tables to track when a student has taken a module
(easy)and which questions they got wrong in each module and then be able to
run various kinds of reports on questions that students got wrong in various
ways. It seems like this should be simple, but I'm struggling with it. Does
anyone know where an example of this type of schema would be?
Thanks for your help in advance!
-Brian
to be efficient, you need to break down into multiple tables. otherwise
u'll end up something like this:
tblID|studentID|moduleID|questionID|answerID|
1 |111111111|aaaaaaaa|xxxxxxxxxx|yyyyyyyy|
2 |111111111|aaaaaaaa|xxxxxxxxx2|yyyyyy10|
3 |111111111|aaaaaaaa|xxxxxxxxx3|yyyyyy20|
4 |333333333|aaaaaaaa|xxxxxxxxxx|yyyyyyyy|
you get the idea, a lot of data will be repeated. not a good idea.
jc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
