Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment 1 XML Database: XPath Consider the XML documents (data.xml) about airport traffic Express the following XPath queries : The last ticket of the third

Assignment 1

XML Database: XPath

Consider the XML documents (data.xml) about airport traffic

Express the following XPath queries:

  1. The last ticket of the third ight (in the document order)
  2. Flight numbers operated by A6-EOQ aircraft on 2019-10-13
  3. Lines with duration above the overall average
  4. Overall number of ights heading to any airport in Germany (DEU) on 2019-10-18

PLEASE MAKE SURE IT'S XPath QUEIRES

I don't knew what more information should I add but the data.xml document is here

Emirates Airlines

Vclav Havel Airport

Dubai International Airport

355

4469

Lufthansa

Vclav Havel Airport

Franz Josef Strauss Airport

50

266

SAS Scandinavian Airlines

Vclav Havel Airport

Arlanda Airport

110

1090

Lufthansa

Vclav Havel Airport

Frankfurt Main Airport

65

407

EK140

Ivan Trojan

Ji Machek

Jitka Schneiderov

LH1691

EK140

Anna Geislerov

Tatiana Vilhelmov

Pavel Lika

EK140

SK1768

LH1397

EK140

Zdenk Svrk

Ji Menzel

LH1691

LH1397

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database Administration The Essential Reference

Authors: Brian Laskey, David Kreines

1st Edition

1565925165, 978-1565925168

More Books

Students also viewed these Databases questions

Question

Advance warning and an explanation for the layoff.

Answered: 1 week ago

Question

Assessment of skills and interests.

Answered: 1 week ago