Given te Transcript database (XML document) Assume that each CrsTaken element has Grade subelement child Write the following queries in XQuery Create a list of courses with the semester when the course was taught Find all students who had A for CS 140 Find the courses that have been taken by at least 20 students List each course with the number of students taken this course in a particular semester Find the courses that have been taken by a student with name Kate Jones or a student having Stuid 2234 Find students who have taken at least 4 courses in Fall 2017 List all courses in which every enrolled student took CS 242 Transcripts CS308 F1997 A MAT 12 3 F1 9974 Semester A eCrsTaken CS305 F1995 B cs30S F1995 A 12345 Joe Blow w jbloe Name CS315 F1997 A CS305 S1996 B MAT123 CrsCode semester F1997 A Transcripts CS308 F1997 A MAT 12 3 F1 9974 Semester A eCrsTaken CS305 F1995 B cs30S F1995 A 12345 Joe Blow w jbloe Name CS315 F1997 A CS305 S1996 B MAT123 CrsCode semester F1997 A

The Answer is in the image, click to view ...

Question: Given te Transcript database (XML document). Assume that each CrsTaken element has Grade subelement/child. Write the following queries in XQuery. Create a list of courses

Given te Transcript database (XML document). Assume that each CrsTaken element has Grade subelement/child. Write the following queries in XQuery.

Create a list of courses with the semester when the course was taught.

Find all students who had A for CS 140.

Find the courses that have been taken by at least 20 students.

List each course with the number of students taken this course in a particular semester.

Find the courses that have been taken by a student with name Kate Jones or a student having Stuid 2234.

Given te Transcript database (XML document). Assume that each CrsTaken element has

Find students who have taken at least 4 courses in Fall 2017.

List all courses in which every enrolled student took CS 242

Transcripts> = CS308 F1997 A MAT 12 3 F1 9974/Semester> A- eCrsTaken> CS305 F1995 B+ cs30S F1995 A- - "12345" "Joe Blow"w"jbloe"/> Name- CS315 F1997 A CS305 S1996 B+ MAT123/CrsCode. semester>F1997 A Transcripts> = CS308 F1997 A MAT 12 3 F1 9974/Semester> A- eCrsTaken> CS305 F1995 B+ cs30S F1995 A- - "12345" "Joe Blow"w"jbloe"/> Name- CS315 F1997 A CS305 S1996 B+ MAT123/CrsCode. semester>F1997 A

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

BMGT 488 Assignment Grading Rubrics Project Descriptions Always submit your best, most thoughtful work. Assignments should be well organized and should demonstrate the level of writing expected of...

Please help with this. Text below BCS 101 - Programming Concepts and Problem Solving This course will provide an introduction to programming logic and problem solving techniques using different...

UNIVERSITY OF REGINA Department of Computer Science CS 215 Web & Database Programming Winter 2021 Assignment #4: Micro-Blogging Website Database Design & Implementation Due: Tuesday March 16, 2021 by...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

1) You are to write a brief discussion of your solution, i.e. how you approached the modeling problem and any issues you may have encountered (maximum of page) 2) You are to write all applicable...

I need a solution for this. create an ERD.. also create database. m project lves, and Scott Incorporated is an agency that specializes in representing clients in the fields of sport nment. Given the...

Please answer the questions, The material is DataBase The three pictures are the same question, but for a long time to complement some BONUS QUESTION NO. 3: MANDATORY/DOPTIONAL (5 POINTS) Given the...

QUESTION NO.3: MANDATORY OPTIONAL/O Boxts (5 POINTS) Given the following database sample instance, write the following SQL queries: (CL03) Retrieve the course names of all the courses that offered by...

Data base QUESTION NO. 3: MANDATORY DOCTRINA. O BNS (6 POINTS) Given the following database sample instance, write the following SQL queries: (CLO3) Student Name Student number Class Smith 17 1 Brown...

Styles QUESTION NO. 3: MANDATORY/OPTIONAL / BONUS (5 POINTS) Given the following database sample instance, write the following SQL queries: (CLO 3) Student Name Smith Brown Student number Class 17 1...

Chris Ruth, president of Fairazon Industries Inc., believes that reporting operating cash flow per share on the income statement would be a useful addition to the companys just completed financial...

A farmer harvested 21 fewer bushels of sweet corn this year than the previous year. If the farmer's sweet corn crop is planted across 3 acres, what is the average loss per acre?

Question 5 1 1 pts A hedge fund wants to borrow $ 1 0 0 , 0 0 0 using a repurchase agreement. If the haircut is 2 % , what is the market value of the collateral that the hedge fund must deliver to...

Chemistry Mole Calculation Quiz Name Date Write the chemical formula and then calculate the molar mass - round to the tenths place and include units. 1. Iron (II) oxide 2. Sulfuric acid 3. Dinitrogen...

What is the difference between Needs and GAP Analyses?

What are ERP suites? Are HCMSs part of ERPs?

An economy is operating with output $400 billion below its natural rate, and fiscal policymakers want to close this recessionary gap. The central bank agrees to adjust the money supply to hold the...