Create a document that for each professor lists the name and classes taught. (A class is identi?ed by a course code and semester.)
Use the document structure described in Exercise 15.23 to formulate the following queries in XQuery:
{
FOR $p IN doc("http://xyz.edu/professor.xml")//tuple
LET $tch := doc("http://xyz.edu/teaching.xml")
//tuple[ProfId/@value=$p/Id/@value]
RETURN
$p/Name
{
FOR $t IN $tch
RETURN
$t//CrsCode,
$t//Semester
}
}
Computer Science & Information Technology
You might also like to view...
A(n) ________ network uses radio waves as its transmission medium
Fill in the blank(s) with correct word
Computer Science & Information Technology
Flash memory
A) Uses light B) Is nonvolatile C) Clears when the computer powers down D) Has a fast refresh rate
Computer Science & Information Technology
Typically, in hierarchical database management systems, a one-to-one relationship exists between data entities.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
With the ________________, you can create line shapes, arrows, hollow lines, and dotted lines with various dash and gap settings.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology