Create an XML document that lists all students by name and, for each student, lists the student’s transcript. The transcript records must include course code, semester, and grade.
Use the document structure described in Exercise 15.23 to formulate the following queries in XQuery:
{
FOR $s IN doc("http://xyz.edu/student.xml")//tuple
LET $tr := doc("http://xyz.edu/transcript.xml")
//tuple[StudId/@value=$s/Id/@value]
RETURN
$s/Name
{
FOR $t IN $tr
RETURN
$t//CrsCode,
$t//Semester,
$t//Grade
}
}
You might also like to view...
Intermediate Stream operation ________ results in a stream with the specified number of elements from the beginning of the original stream.
a. distinct b. map c. filter d. limit
When establishing a relationship, common fields do NOT necessarily need to have:
A) the same data type. B) common data. C) the same field size. D) the same field name.
When a comment is inserted, by default, the date shows ________ the name of the person commenting
A) to the right of B) to the left of C) above D) below
Which of these is not one of the four goals of incident management?
A. Make the user more self-reliant B. Complete the incident in the least amount of time possible C. Manage stress levels for both user and support agent D. Provide the user with the information he or she needs