Subject: XML and its Application (report assess) Level: Undergraduate Grade: 2017 Student Name: _ Student ID: Score: Total I. Projects List Project 1: Project Name: Experiment on DTD Project Description: Given a XML document in part III Please Write down the DTD according to the document and the following requirements 1) The element publisher is required. 2) The count of element author is no more than 5. 3) Add another three features for the element book with attribute or sub-element, which is optional. 4) Add another three features for the element author with attribute or sub-element, which is optional. Project 2: Project Name: Experiment on Schema Project Description: Given a XML document in part III Please Write down the XML schema according to the document and the following requirements 1) The element publisher is required. 2) The count of element author is no more than 5. 3) Add another three features for the element book with attribute or sub-element, which is optional. 4) Add another three features for the element author with attribute or sub-element, which is optional. 3) Add another three features for the element book with attribute or sub-element, which is optional. 4) Add another three features for the element author with attribute or sub-element, which is optional. Project 3: Project Name: Experiment on XPath Project Description: Given a XML document in part III Please Write down the XPath expression to complete the following requirements 1) Write XPath expression to find the information of the first author of all books 2) Write XPath expression to find the information of the first author of the book published in 2020 3) Write XPath expression to find the information of the book published by Wuhan University. 4) Write XPath expression to find the information of the book Written by Zhang San. Project 4: Project Name: Experiment on XQuery Project Description: Given a XML document in part III. Please Write down the XQuery language to complete the following requirements 1) Write XQuery language to find the title and the first authors of all books 2) Write XQuery language to find the title and the first author of the books which are published in 2020. 3) Write XQuery language to find the title and the first author of the books which are published by Wuhan University. 4) Write XQuery language to find the title and the first author of the books which are written by Zhang San. Project 5: Project Name: Experiment on XML within MSSQL. Project Description: Given a XML document in part III. Please Write down the SQL script to complete the following requirements 1) Write SQL script with openxml" and "select into" to decompose the information within the xml to three different data table named book, author and publisher. 2) Write SQL script with "for xml" to query the information within the above three tables, and get the result same to books.xml II. Requirements 1) Use XMLSPY/Oxygen to carry out the project 5 and any other two projects (or experiments) above, and Project 5: Project Name: Experiment on XML within MSSQL. Project Description: Given a XML document in part III. Please Write down the SQL script to complete the following requirements 1) Write SQL script with "openxml" and "select into" to decompose the information within the xml to three different data table named book, author and publisher. 2) Write SQL script with "for xml" to query the information within the above three tables, and get the result same to books.xml II. Requirements 1) Use XMLSPY/Oxygen to carry out the project 5 and any other two projects (or experiments) above, and finish your course report according to your choice and the template at the same time. 2) Not all 5 projects are required, but more projects are encouraged and awarded more score until 100 points. 3) The deadline is 2021/1/10 12:00. III. XML Document Content in books.xml Wuhan UniversityCauthor >Zhang San Li Si Zhang SanCauthor>Wang Wu Wuhan University Cauthor >Li SiCauthor > Wang Wu spublisherQinghua UniversityWang Wu Ma Liuprojects are required, but projects are encouraged and awarded more score until 100 points. 3) The deadline is 2021/1/10 12:00 III. XML Document Content in books.xml publisher Wuhan UniversityCauthor >Zhang San Li Si Qinghua UniversityCauthor>Zhang San Wang Wu Wuhan UniversityLi Si Cauthor > Wang Wu Wang Wu Ma Liu Wuhan UniversityCauthor>Ma Liu Yuan Qi Qinghua UniversityZhang san