Subject: How to organize and query related data (beginners question)
From: "Mark Marlow" <mark@xxxxxxxxxxx>
Date: Thu, 21 Apr 2005 06:02:33 -0400
|
Given two sets of data shown below. With Test decribing
a test, and Student describing a student who took a test. How
to structure the XML and query it to render
each student, along with their question, answer and whether it
was the correct answer, and a description of the question?
TIA!
Test
Test-Items
Section
Questions
Question-number
Correct-Answer
Description
School
Student
Name
Section
Answers
Question-number
Answer-given
|