• reopened by
1,053 views
0 0 votes

Consider the following XML DTD describing course information in a university:
 

<!ELEMENT Univ (Course+, Prof+)>
<!ELEMENT Course (Title, Eval*)>
<!ATTLIST Course Number ID #REQUIRED Instructor IDREF #IMPLIED>
<!ELEMENT Title (#PCDATA)>
<!ELEMENT Eval (#PCDATA)>
<!ATTLIST Eval Score CDATA #REQUIRED>
<!ELEMENT Prof EMPTY>
<!ATTLIST Prof Name ID #REQUIRED Teaches IDREF #IMPLIED>


What is returned by the following XQuery?

let $as := / /@Score
for $c in /Univ/Course[Eval]
let $cs := $c/Eval?@Score
where min($cs) > avg($as)
return $c

  1. The professor with the lowest course evaluation
  2. Professors who have all their course evaluations above the university average
  3. The course with the lowest evaluation
  4. Courses with all evaluations above the university average

Please log in or register to answer this question.

Answer:
Position:
Show:

Related questions

2 2 votes
3 answers 3 answers
2.6k
2.6k views
Ishrat Jahan asked Nov 1, 2014
2,613 views
A software project has four phases P1, P2, P3 and P4. Of these phases, P1 Is the first one and needs to be completed before any other phase can commence. Phases P2 and P3...
2 2 votes
2 answers 2 answers
2.4k
2.4k views
Ishrat Jahan asked Nov 1, 2014
2,365 views
A software project has four phases P1, P2, P3 and P4. Of these phases, P1 Is the first one and needs to be completed before any other phase can commence. Phases P2 and P3...
2 2 votes
1 1 answer
2.9k
2.9k views
Ishrat Jahan asked Nov 1, 2014
2,896 views
$x + y/2 = 9$$3x + y = 10$What can be said about the Gauss-Siedel iterative method for solving the above set of linear equations?it will convergeIt will diverseIt will...
2 2 votes
1 1 answer
2.5k
2.5k views
Ishrat Jahan asked Nov 1, 2014
2,542 views
$x + y/2 = 9$$3x + y = 10$The value of the Frobenius norm for the above system of equations is$0.5$$0.75$$1.5$$2.0$