Create the list of all courses in which Joe Public received an A.

Using the document structure described in Exercise 15.23, formulate the following queries in XQuery:



{
LET $sset := doc("http://xyz.edu/student.xml")
//tuple[Name/@value="Joe Public"]
FOR $c IN doc("http://xyz.edu/course.xml")//tuple,
$s IN $sset
WHERE doc("http://xyz.edu/transcript.xml")
//tuple[StudId/@value=$s/Id/@value
and Grade/@value="A"]
RETURN $c
}

Computer Science & Information Technology

You might also like to view...

To search for a word that starts with "ar" you would enter ________

A) ar? B) ar# C) ar* D) ar!

Computer Science & Information Technology

A _________ states what is assumed to be true when the method is called.

(a) prescript (b) postscript (c) precondition (d) postcondition

Computer Science & Information Technology