1. a)<wnyc><piece id = “3”><time>1:01</time><title>Mad Rush</title><composer>J.Sibelius</composer><conductor>L.Bernstein</conductor><soloist>A.Karis</soloist></piece><piece id = “4”><time>1:47</time><title>Andante</title><composer>L.Beethoven</composer></piece><piece id = “5”><time>1:57</time><title>Upon Enchanted Gound</title><composer>A.Hovhaness</composer><soloist>Y.Kondonassis</soloist><soloist>F.Hendrickx</soloist><soloist>H.Coryn</soloist></piece></wync>b) FOR $x IN distinct-value(document(“wync.xml”)/piece[title/text() = “Mad Rush”][composer/text() = “J.Sibelius”]/conductorRETURN {$x}c) FOR $t IN document(“wync.xml”)/piece[title/text()=”Adnante”]/timeFOR $s IN distinct-value(document(“wync.xml”)/piece[time=$t]/soloist)RETURN {$s}d) <wnyc-by-solo><solo><name>A.Karis</name><conductor><name>L.Bernstein</name><piece><title>Mad Rush</title><composer>J.Sibelius</composer></piece></conductor></solo><solo><name>Y.Kondonassis</name></solo><solo><name>F.Hendrickx</name></solo><solo><name>H.Coryn</name></solo></wnyc-by-solo>2. There are 10000/50 = 200 pages in Purchase and 2000/10 = 200 pages in Product.a. 200 + 200 * 200 = 40200b. 200 + 200 / 100 * 200 = 600c. Block nested loop join: 200 + 200 = 400d. 200 + 2000 * (1.2 + 1) = 46003.a. SELECT name, MAX(citations)FROM Author A, Paper P1WHERE A.pid = P1.pid AND 3 <= (SELECT count(*)FROM Author A2, Paper P2WHERE P2.pid = P1.pid AND A2.pid = P2.pid)GROUP BY nameb. SELECT year, MAX(citations)FROM PaperWHERE citations>20GROUP BY yearc. Nod. CREATE TRIGGER CITETIMEAFTER INSERT ON CitesFOR EACH ROWWhen ( Paper1.year < Paper2.year AND Paper1.pid = pid1 AND Paper2.pid = pid2)DELETE (paper1,
View Full Document
Unlocking...