@lists.mysql.com
Subject: RE: Student question answer schema
Brian,
Sound like you need to normalize your data. Quick review of what you
sent to the list shows that you need 5 tables:
* student table - each student description
* module table - each module description
* question table - each question
student has or
is taking.
Best,
Mikhail Berman
-Original Message-
From: JC [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 11:22 AM
To: Brian Menke
Cc: mysql@lists.mysql.com
Subject: Re: Student question answer schema
On Mon, 10 Apr 2006, Brian Menke wrote:
> Does anyone happen
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 i
om: Brian Menke [mailto:[EMAIL PROTECTED]
Sent: Monday, April 10, 2006 10:38 PM
To: mysql@lists.mysql.com
Subject: Student question answer schema
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
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 studen
