SophiaPretty
$14/per page/Negotiable
CAN ANYONE HELP ME WITH THIS?
I REALLY NEED HELP WITH SQL/XSL/HTML
This exercise consists of XMLquestions on XSL and XPath.
· Use the following Final-StudentRoster.xml XML for the questions.
· Use an XML tool such as Oxygen or even the W3Schools.com’s Online XSLT Editor
o For the online editor, click “Try It Yourself”, and copy & paste the above XML.Here is an example.
· Upload your word document to Canvas by the due date.
<?xmlversion="1.0" encoding="UTF-8" ?>
<!-- file name:Final-StudentRoster.xml -->
<roster>
<student class="Financing">
<SN>2005133115</SN>
<name>Bob McRobertson</name>
<gender>male</gender>
<birthday>10/21/1986</birthday>
<score>605</score>
</student>
<student class="Financing">
<SN>2005133110</SN>
<name>Alicia Turnbuckle</name>
<gender>female</gender>
<birthday>10/25/1985</birthday>
<score>620</score>
</student>
<student class="International Financing">
<SN>2005131136</SN>
<name>Gertrude Frauleiner</name>
<gender>female</gender>
<birthday>05/28/1986</birthday>
<score>612</score>
</student>
<student class="Insurance">
<SN>2005132012</SN>
<name>Marth Ingrids</name>
<gender>female</gender>
<birthday>06/19/1986</birthday>
<score>605</score>
</student>
<student class="Financing">
<SN>2005133108</SN>
<name>Judith Judeberg</name>
<gender>female</gender>
<birthday>03/15/1987</birthday>
<score>581</score>
</student>
<student class="Software Engineering">
<SN>2005144118</SN>
<name>Dorian McMichaels</name>
<gender>female</gender>
<birthday>05/15/1991</birthday>
<score>595</score>
</student>
<student class="Accounting">
<SN>2005155119</SN>
<name>Bobby McFerris, III</name>
<gender>male</gender>
<birthday>12/25/1996</birthday>
<score>615</score>
</student>
</roster>
1. Write one XSL to display Final-StudentRoster.xmlin an HTML table.Use an XML tool such as Oxygen or even the W3Schools.com’s Online XSLT Editor (click “Try It Yourself”, and copy & paste the above XML). Extra Credit (1 point): also display the student’s class.
You may use the table structure from this basic HTML content, filling-in the XSL where appropriate:
<html>
<body>
<h2>Title Goes Here</h2>
<table border="1">
<trbgcolor="lime">
<th>Column heading 1</th>
<th>Column heading 2</th>
<th>column heading 3</th>
<th>column heading 4</th>
<th>column heading 5</th>
</tr>
<tr>
<td>values for heading 1...</td>
<td>values for heading 2...</td>
<td>values for heading 3...</td>
<td>values for heading 4...</td>
<td>values for heading 5...</td>
</tr>
</table>
</body>
</html>
2. Write one XSL to display a similar HTML table to display the student information for students in either the ‘Financing’ or ‘International Financing’ classes from theFinal-StudentRoster.xml.
3. Write one XSL to display a similar HTML table to display the female student information, sorted by score ranking from the Final-StudentRoster.xml. Extra credit (1 point): Order indescending order (highest to lowest).
4. Draw the node-tree of theFinal-StudentRoster.xml below.
5. Based on the XML and the above node-tree, answer these quick questions
a. What is the parent node of node “name”?
b. What are the ancestor nodes of node “name”?
c. What are the child nodes of node “student”?
d. What are the sibling nodes of node “gender”?
6. Using the Final-StudentRoster.xml, form the following XPath;
a. Select all the students.
b. Select the name(s) of student(s) with scores higher than 610.
c. Select the student in Accounting.
7. Using the Final-StudentRoster.xml, form the following XQuery using FLWOR expressions:
a. Select all the finance students, sorted by score ranking.
b. BONUS Extra Credit (2 points): select all the students whose score is lower than average, sorted by score ranking.
c. BONUS Extra Credit (1 points): convert theFinal-StudentRoster.xml to JSON, copy below:
Attachments: