1) Consider the following DTD. All unspecified elements are #PCDATA. ... ]> Write the following queries in XQuery. Assume Last names of authors are unique. (a) List all books authored by Ullman. (b) List articles published in Vol. 32 No. 2 of ACM Transactions on Database Systems. (c) List journals that published an article on XML in 2001 (that is, “XML” appears in the title of the article). (d) List authors that have published a book in 2001 and another book in 2003. (e) List publishers, and for each publisher list the books they have published as subelements. Choose appropriate tags for your output. (f) List every author, and for each author list the number of articles he/she published in 2001. Choose appropriate tags for your output. I want answers for D,E,F i have answers for A,B,C for reference I am posting the entire questions with all subparts but i need answer for subparts d,e,f.
Concepts in Designing Database
A database design is the process of data organization based on a database model. The process deals with identifying what data should be stored in a database and how data elements relate to each other.
Entity Relationship Diagram
Complex real-world applications call for large volumes of data. Therefore, it is necessary to build a great database to store data safely and coherently. The ER data model aids in the process of database design. It helps outline the structure of an organization’s database by understanding the real-world interactions of objects related to the data. For example, if a school is tasked to store student information, then analyzing the correlation between the students, subjects, and teachers would help identify how the data needs to be stored.
1)
Consider the following DTD. All unspecified elements are #PCDATA.
<!DOCTYPE bibliography [
<!ELEMENT book (title,author+,year,publisher,place?)>
<!ELEMENT article (title,author+,journal,year,number,volume,pages?)>
<!ELEMENT author (last_name, first_name)>
...
]>
Write the following queries in XQuery. Assume Last names of authors are unique.
(a) List all books authored by Ullman.
(b) List articles published in Vol. 32 No. 2 of ACM Transactions on
(c) List journals that published an article on XML in 2001 (that is, “XML” appears in the title of the
article).
(d) List authors that have published a book in 2001 and another book in 2003.
(e) List publishers, and for each publisher list the books they have published as subelements. Choose
appropriate tags for your output.
(f) List every author, and for each author list the number of articles he/she published in 2001. Choose
appropriate tags for your output.
I want answers for D,E,F i have answers for A,B,C for reference I am posting the entire questions with all subparts but i need answer for subparts d,e,f.
Step by step
Solved in 4 steps