Assignment 2: Spatial &Temporal Data/XML Due: Wednesday, September 20, 2017 11: 59PM Section A: Spatial &Temporal Data For the 1st section of the assignment, the objective is to define and utilize spatial and temporal data repositories. Reference SQL/MM for handling spatial data to complete the Skill Builder exercises: I. Using your RDMS service (MySQL) to create the three tables for the example and insert the rows listed in the preceding SQL code Assignment Help: Use the political units repository example to create the solution. The political unit repository solution includes the following: a. Data model for political units b. Political unit DB definition. c. Insert statements for populating the DB II. Select 1 of the Skill Builder exercise queries to construct the following: 1. What is the area of Northern Ireland? Because Northern Ireland is part of the United Kingdom and miles are still often used to measure distances, report the area in square miles. What is the direct distance from Belfast to Londonderry in miles? 2. What is the northernmost city of the Republic of Ireland? 3. Your query solution must be coded and you must also provide a screen shot of the query results (output) To receive full credit for this section, parts I & II must be completed and submitted by the due date. Section B: XML For the 2nd section of the assignment, the objective is to manage data exchange via XML by defining, creating and coding XML schemas and style sheets and formats. Using the following XML file link, answer chapter exercises 5a and 6a - List all the customers: XML file link: http: //richardtwatson.com/xml/customerpayments xml 5a: Your XML conversion (XPath syntax) solution must be coded. 6a: Your XML conversion (XQuery syntax) query solution must be coded Assignment Help: For 5a, reference the XPath Navigation Examples. For 6a, reference the XQuery CD Titles List. To receive full credit for this section, exercises 5a & 6a must be completed and submitted by the due date. Assignment 2: Spatial &Temporal Data/XML Due: Wednesday, September 20, 2017 11: 59PM Section A: Spatial &Temporal Data For the 1st section of the assignment, the objective is to define and utilize spatial and temporal data repositories. Reference SQL/MM for handling spatial data to complete the Skill Builder exercises: I. Using your RDMS service (MySQL) to create the three tables for the example and insert the rows listed in the preceding SQL code Assignment Help: Use the political units repository example to create the solution. The political unit repository solution includes the following: a. Data model for political units b. Political unit DB definition. c. Insert statements for populating the DB II. Select 1 of the Skill Builder exercise queries to construct the following: 1. What is the area of Northern Ireland? Because Northern Ireland is part of the United Kingdom and miles are still often used to measure distances, report the area in square miles. What is the direct distance from Belfast to Londonderry in miles? 2. What is the northernmost city of the Republic of Ireland? 3. Your query solution must be coded and you must also provide a screen shot of the query results (output) To receive full credit for this section, parts I & II must be completed and submitted by the due date. Section B: XML For the 2nd section of the assignment, the objective is to manage data exchange via XML by defining, creating and coding XML schemas and style sheets and formats. Using the following XML file link, answer chapter exercises 5a and 6a - List all the customers: XML file link: http: //richardtwatson.com/xml/customerpayments xml 5a: Your XML conversion (XPath syntax) solution must be coded. 6a: Your XML conversion (XQuery syntax) query solution must be coded Assignment Help: For 5a, reference the XPath Navigation Examples. For 6a, reference the XQuery CD Titles List. To receive full credit for this section, exercises 5a & 6a must be completed and submitted by the due date