Question: Suppose the document below contains data for battleships management. In this document, data about ships is nested within their class element, and information about battles

Suppose the document below contains data for battleships management. In this document, data about ships is nested within their class element, and information about battles appears inside each ship element. Guadalcanal Guadalcanal Surigao Strait Surigao Strait Denmark Strait Malaya North Cape 1. XPath Query Expression. For each question below, (1) Write the query in XPath. (2) Write the expected query result For these questions, you dont need to show the execution of the XPath query with a particular XML database system. 1-1. Find the names of all ships. 1-2. Find all the Class elements for classes with a displacement larger than 35000. 1-3. Find all the Ship elements for ships that were launched before 1917. 1-4. Find the names of all ships that were in battles. 2. Querying XMLType Data with SQL Functions 2-1. Create BattleShip_XML table of XMLType type. 2-2. Populate the battleship XML document to the BattleShip_XML table using INSERT INTO VALUES (); 2-3. Implement the XPath query in Q1-1 using a SQL function EXTRACT with the BattleShip_XML table. Submit the SQL statement and query result. SELECT FROM BattleShip_XML; 2-4. Implement the XPath query in Q1-2 using a SQL function EXTRACT with the BattleShip_XML table. Submit the SQL statement and query result. SELECT FROM BattleShip_XML; 3. Querying the XML document with XQuery (FLWOR) expressions 3-1. Using createResource_battleShip.XML.sql provided, register the battleShip.xml in the XML DB repository of your Oracle account. The battleship XML document will be located in /public/battleShip.xml 3-2. Implement Q1-3 using an XQuery with FLWOR expressions on /public/battleShip.xml. You dont need to use the BattleShip_XML table for that. You may need to use this template: SELECT XMLQuery ( ' ' RETURNING CONTENTS) FROM DUAL; The result format of Q3-2 should be the same with the result format of Q1-3. Submit the SQL statement and the query result. 3-3. Implement Q1-4 using an XQuery with FLWOR expressions on /public/battleShip.xml. You dont need to use the BattleShip_XML table for that. For the result format, include tag. The expected result looks like : .

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!

And here is the XML data from the figure. Exercise 12.1.2: The document of Fig. 12.6 contains data similar to that used in our running battleships exercise. In this document, data about ships is...

A Case Study of the Navy ABSTRACT We present here a case study of an organization within the U.S. Navy that created a new organizational construct and performance management system. We explore the...

Accuracy please. Decipher the abnomalate networking algorithms by developing a unique application that performs on automotive cyber intelligence. I expect detailed codes, screenshots of app...

Solve the following question and add screenshot of the execution. Also, include vds diagram and matricize the output. Make sure to explain every line of your answer. I will give downvote if you don't...

Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

I have to create a program in C and I can't figure it out. The program has to read a source file. Please help. /******************************************************************** PROJECT: Glossary...

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

Modified accrual basis revenue recognition is often referred to as near cash basis revenue recognition. Explain why this statement probably is made. Do you agree? Explain.

The shareholders of Zimtex Electronics Inc. are considering selling their shares. The company's statement of financial position is as follows: The company has 25,000 shares outstanding, which are...

q , theory focuses on the needs that drive intrinsic, motivation, which is longer imting and has a nore poitive inpact on tadk performance than otrinic motivation. Need hirrancty Acpuired reeds Self...

3. (12 pts) Consider a staircase with n steps. Each step i has some non-negative cost, cost[i]. Steps are indexed from 0 to n-1. You want to climb these stairs. Once you pay the cost, you can either...

15-5 If you were a manager in a company that operates in many countries, what criteria would you use to determine whether an application should be developed as a global application or as a local...

15-3 What are the challenges posed by global information systems and management solutions for these challenges?

internationalization of business?