Question: Write queries in XQuery on the bibliography DTD fragment as shown below to do the following. a. Find all authors who have authored a book

Write queries in XQuery on the bibliography DTD fragment as shown below to do the following.

a. Find all authors who have authored a book and an article in the same year.

b. Display books and articles sorted by year.

c. Display books with more than one author.

· · · similar PCDATA declarations for year, publisher, place, journal, year,

number, volume, pages, last-name and first-name

] >

Step by Step Solution

★★★★★

3.47 Rating (177 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a Find all authors who have authored a book and an ... View full answer

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

Document Format (1 attachment)

Word file Icon

16-CS-DB (242).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Q:

Write a query in XQuery on the XML representation as shown below to compute the left outer join of customer elements with account elements. account-number ID #REQUIRED owners IDREFS #REQUIRED >...

Q:

Write a query in XQuery on the XML representation as shown below to find the total balance, across all accounts, at each branch. A-101 Downtown 500 A-102 Perryridge 400 A-201 Brighton 900 Johnson...

Q:

Let T be an ordered tree with more than one node. Is it possible that the preorder traversal of T visits the nodes in the same order as the postorder traversal of T? If so, give an example;...

Q:

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 -...

Q:

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 -...

Q:

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 -...

Q:

You are writing a letter to the editor telling them if this article should be published in The Shorthorn(Local College news paper) and why. To earn an A, your paper should include a thesis that is...

Q:

SIGMA MICRO FINANCE: EARLY BATTLE FOR SURVIVAL Source: Richard Ivey School of Business Foundation (names have been disguised for privacy issues) On August 14, 2013, Ziad Habib, the founder and chief...

Q:

THE BRITISH JOURNAL OF CRIMINOLOGY Vol. 17 January 1977 No. 1 NILS CHRISTIE (Oslo) f Abstract CONFLICTS are seen as important elements in society. Highly industrialised societies do not have too much...

Q:

Please Read!!! Please DO NOT copy and past from internet or another student or somewhere else, there is a safe assign program will find any plagiarism...please read the book and write an assignment...

Q:

The lightbulb in Fig. 2.122 is rated 120 V, 0.75 A. Calculate Vs to make the lightbulb operate at the rated conditions?

Q:

How many ways can you think to connect 4 resistors using series and parallel combinations? Draw at least 5 of the conditions

Q:

If the consignee can't find a buyer within an agreed upon time, the consignee Multiple choice question. returns the goods to the consignor. may keep the goods. must purchase the goods.

Q:

P4 is prepared by heating phosphate rock [principally Ca3(PO4)2] with sand and coke: Ca3(PO4)2(s) + SiO2(s) + C(s) -> CaSiO3(s) + CO(g) + P4(g) [unbalanced] How many kilograms of phosphate rock...

Q:

Suppose the amount of time it takes a Mr Rigg, a pilot for a national airline, to land a plane from announcement to touch down is uniformly distributed from 0 to 25 minutes. Find the probability...

Q:

The speed of sound in a particular fluid is 1480 m/s. What is the wavelength of sound waves of frequency 23 kHz that travel through the fluid? A. 6.4 cm B. 5.5 cm C. 2.1 m D. 3.2 cm 2. When a mass 5...

Q:

An IgG antibody that specifically recognizes a protein of interest, p50, was used to isolate p50 from a whole-cell lysate. The resulting protein mixture can undergo SDS-PAGE to separate p50 from IgG....

Q:

If the R f of a sample of anthracene on a TLC plate developed with an eluent of hexanes:ethyl acetate (1:1) was found to be 0.65, what should its Rf be if the eluent was changed to only petroleum...

Q:

The following data represent the viscosity (friction, as in automobile oil) taken from 120 manufacturing batches (ordered from lowest viscosity to highest viscosity).

Q:

Consider the issue of interesting orders in optimization. Suppose you are given a query that computes the natural join of a set of relations S. Given a subset S1 of S, what are the interesting orders...

Q:

Consider the query: select * from r, s where upper(r.A) = upper(s.A) where upper is a function that returns its input argument with all lowercase letters replaced by the corresponding uppercase...

Q:

Show that, with n relations, there are (2(n1))!(n1)! different join orders. A complete binary tree is one where every internal node has exactly two children. Use the fact that the number of different...

Q:

Write pseudocode for an iterator that implements indexed nested-loop join, where the outer relation is pipelined. Your pseudocode must define the standard iterator functions open(), next(), and...

Q:

Suppose you need to sort relation r using sort-merge and mergejoin the result with an already sorted relation s. a. Describe how the sort operator is broken into sub operators to model the pipelining...

Q:

Debt consolidation loans are very appealing because they offer liquidation to those who are in good standing with their creditors. they offer hope to those who can't keep up with their current...