Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Store the other XML document in a native database, such as eXistDB. Run the queries in your variation. The minimal requirements: All queries run.

image text in transcribed1. Store the other XML document in a native database, such as eXistDB. Run the queries in your variation. The minimal requirements: All queries run. The maximal requirements: Appropriate constructs used, XQuery used in at least one query.

xml document is below

43-1225259

Aivee

946 Northland Park

tgurges@privacy.gov.au

USA

Gilles Strettell

PRO7965

Pie Pecan

9.97

Ellerey Fitzsimons

PRO0809

Wild Boar - Tenderloin

6.11

Damon Weins

87-1586187

Innojam

457 Surrey Street

bhubani@eventbrite.com

Spain

Ardyce Armatidge

PRO7596

Tea - Green

13.93

Arleyne Lestrange

PRO3925

Bread - Roll, Canadian Dinner

12.88

Gertrud MacLaig

48-8220458

Tavu

1 Duke Street

sshevlanm@hao123.com

Spain

Mavis Bulled

PRO2354

Wine - White, Ej Gallo

4.99

Itch Tant

27-0904612

Meezzy

52 Sundown Hill

rreardond@usnews.com

USA

Baudoin Kulver

PRO9059

Lamb - Pieces, Diced

9.96

Emelia Pelchat

45-6876967

Zoomcast

156 Waubesa Junction

bpapachristophorout@alibaba.com

Germany

Ellerey Fitzsimons

PRO9021

Salmon - Atlantic, No Skin

3.91

Colly Butt Gow

42-4850091

Quinu

924 Bowman Street

ndayerk@forbes.com

USA

Ailee Ferrettini

PRO3191

Pepper - Sorrano

4.9

Dre Skrine

PRO1890

External Supplier

15.6

Kelcie Ruske

73-4993921

JumpXS

664 Sundown Center

melsopf@goo.ne.jp

USA

Kaiser Verlinde

PRO4857

Longos - Grilled Chicken With

9.55

Tobie Conring

62-7273666

Eabox

9537 Ronald Regan Trail

owhitham8@phoca.cz

Germany

Marcille Darrigone

PRO2086

Petite Baguette

19.12

Gweneth Newis

PRO2899

Bonito Flakes - Toku Katsuo

14.29

Aurthur Gulleford

21-7182056

Ooba

19 Monument Lane

iomullen2@issuu.com

Germany

Lindon Firmager

PRO1813

Pork Loin Bine - In Frenched

7.3

Lindon Firmager

PRO6642

Duck - Fat

12

Meaghan Cuncliffe

05-9304550

JumpXS

0 West Circle

amoundp@wired.com

Spain

Arleyne Lestrange

PRO7412

Tea - Jasmin Green

2.97

Willdon Wolstencroft

PRO3946

Avocado

9.84

Gilles Strettell

62-8435251

Katz

6143 Nevada Road

kwitteringj@homestead.com

Spain

Emelia Pelchat

PRO5483

Beer - Mill St Organic

2.78

Baudoin Kulver

PRO9973

Bread Base - Italian

17.46

Terence Chesnut

PRO9324

V8 Splash Strawberry Banana

2.36

Montague Apple

83-8135860

Eadel

1521 Mallory Street

bgregorina@nationalgeographic.com

Germany

Terence Chesnut

PRO5740

Chicken - Bones

19.32

Corinna House

PRO3119

Turkey - Breast, Boneless Sk On

12.78

Mavis Bulled

PRO5790

Fond - Neutral

10.89

Marcille Darrigone

05-8124623

Shuffledrive

7314 Anhalt Lane

mnoultonn@addtoany.com

USA

Bertie Breffit

PRO5220

Ice Cream - Chocolate

17.69

Bertie Breffit

PRO9608

Vermouth - Sweet, Cinzano

3.11

Corena McCuis

08-6352103

Gabtune

191 Buena Vista Place

abotwrighto@w3.org

USA

Kelcie Ruske

PRO3656

Wasabi Powder

15.1

Ailee Ferrettini

PRO2912

Beer - Sleeman Fine Porter

15.71

Vergil Tome

54-4333660

Demizz

9 Stephen Road

preyne1@jigsy.com

Spain

Aurthur Gulleford

PRO1886

Cheese - Havarti, Roasted Garlic

10.2

Ardyce Armatidge

PRO5861

Pork Salted Bellies

5.35

Aile Beardall

PRO6771

Quail - Whole, Boneless

11.62

Heda Dureden

12-9736415

Nlounge

1901 Donald Crossing

kcalverleye@quantcast.com

France

Colly Butt Gow

PRO6532

Chilli Paste, Ginger Garlic

7.65

Kaiser Verlinde

34-7880930

Cogibox

10404 Karstens Pass

otweedliec@latimes.com

Germany

Dre Skrine

PRO2354

Wine - White, Ej Gallo

4.99

Mavis Bulled

PRO3119

Turkey - Breast, Boneless Sk On

12.78

Corena McCuis

PRO6532

Chilli Paste, Ginger Garlic

7.65

Willdon Wolstencroft

15-0977278

Jayo

389 Orin Crossing

rbagniukq@ehow.com

France

Corinna House

PRO7596

Tea - Green

13.93

Heda Dureden

50-7982327

Mita

29 Alpine Crossing

cfearnleyl@stumbleupon.com

Spain

Heda Dureden

PRO6771

Quail - Whole, Boneless

11.62

Ailee Ferrettini

PRO7412

Tea - Jasmin Green

2.97

Gertrud MacLaig

38-7855330

Wikido

97 Forest Dale Street

bmccorkellr@altervista.org

USA

Gertrud MacLaig

PRO5483

Beer - Mill St Organic

2.78

Vergil Tome

PRO2899

Bonito Flakes - Toku Katsuo

14.29

Bertie Breffit

PRO9021

Salmon - Atlantic, No Skin

3.91

Aile Beardall

92-2159369

Livetube

56 Bonner Court

egall6@vimeo.com

USA

Montague Apple

PRO9973

Bread Base - Italian

17.46

Kelcie Ruske

PRO3656

Wasabi Powder

15.1

Kaiser Verlinde

32-1980497

Skipfire

7769 Mendota Park

lmayger7@princeton.edu

Germany

Tobie Conring

PRO1890

External Supplier

15.6

Arleyne Lestrange

PRO1886

Cheese - Havarti, Roasted Garlic

10.2

Ardyce Armatidge

90-1045424

Devshare

2405 Milwaukee Trail

jeasonb@clickbank.net

France

Meaghan Cuncliffe

PRO2912

Beer - Sleeman Fine Porter

15.71

Gilles Strettell

PRO3946

Avocado

9.84

Montague Apple

PRO3925

Bread - Roll, Canadian Dinner

12.88

Baudoin Kulver

00-7009243

Minyx

1 Grim Park

igaffey4@biglobe.ne.jp

France

Gweneth Newis

PRO9324

V8 Splash Strawberry Banana

2.36

Marcille Darrigone

PRO2086

Petite Baguette

19.12

Aurthur Gulleford

08-8457693

Divape

436 Meadow Ridge Parkway

pchadbourneh@zimbio.com

France

Itch Tant

PRO9059

Lamb - Pieces, Diced

9.96

Dre Skrine

96-3404198

Vipe

98921 Anniversary Drive

marundel9@flavors.me

Germany

Corena McCuis

PRO5740

Chicken - Bones

19.32

Itch Tant

PRO1813

Pork Loin Bine - In Frenched

7.3

Damon Weins

PRO9608

Vermouth - Sweet, Cinzano

3.11

Meaghan Cuncliffe

21-1977940

Layo

775 Morningstar Plaza

ncouvet5@google.es

USA

Aile Beardall

PRO5220

Ice Cream - Chocolate

17.69

Ellerey Fitzsimons

21-0223828

Wikizz

4 Del Mar Street

cmapamg@elpais.com

USA

Damon Weins

PRO4857

Longos - Grilled Chicken With

9.55

Gweneth Newis

PRO3191

Pepper - Sorrano

4.9

Colly Butt Gow

43-8599914

Abatz

73953 Bartillon Center

ecornels0@timesonline.co.uk

Germany

Vergil Tome

PRO6642

Duck - Fat

12

Tobie Conring

PRO5790

Fond - Neutral

10.89

Corinna House

PRO0809

Wild Boar - Tenderloin

6.11

Emelia Pelchat

43-5646919

Browseblab

2174 Fordem Center

mstjohn3@nbcnews.com

Germany

Willdon Wolstencroft

PRO7965

Pie Pecan

9.97

Lindon Firmager

1. Retrieve the email of the company with index 10 (not id!) 2. Retrieve all information about the company with index (not id!) 28 3. Get only codes of all products sold by the company "Eabox". 4. Get all information about products of category A4 which are sold by company with id =28. Result must contain multiple "product" nodes with full information inside

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

Databases Demystified

Authors: Andrew Oppel

1st Edition

0072253649, 9780072253641

More Books

Students also viewed these Databases questions

Question

If you were Akio, what would you do now?

Answered: 1 week ago