Give the DTD for the XML schema
Subject: Distributed Database
Consider a library database system ,which maintains entries for magazines, books and journals. For books titles, subject area ,author names ,publisher name, edition and year are to be stored. For magazines, name ,volume number and date etc are to be stored for journals subject name, subject area, list of articles ,editiors…etc is to be stored. Further for each article the author name, title,and some identification for the journal in which it appeared must be stored.
a) Give the DTD for the XML schema for the described system.
b) Write the following queries in XQuery
i) Display books, Magazine and journals sorted by year.
ii) Find all authors who have written a book and also a journal article in the same year.