Demonstrate an understanding of SQL issues: Illustrate the issues related to Web Technologies as a semi-structured data representation formalism:
Interpret the main concepts and security aspects in data warehousing, and the concepts of data mining and commercial considerations involved in adopting the paradigm it done as soon as possible. 1.1 Produce an XML document (‘WareHouseXMLDocument') for the WAREHOUSE table 1.2 Produce an XML document (‘ProductListXMLDocument') for the PRODUCTLIST table. I.e, a document showing the merged Product and WareHouse XML documents 1.3 Poduce an XML document by reproducing your solution from 1.2 as an amended ProdListXMLDocument showing the inclusion of the construct you have used and how you have used it to resolve the element-name conflict in the ProdListXMLDocument from (1.2) 1.4 Produce an XSD schema document in the ‘ref' format (page-08 of ‘XML Notes Schema') for the following CUSTOMER relation. 3.1 What SQL statement could produce the tree in ‘Given-3' 3.2 In general terms how would you improve the cost of processing this tree (you do not need to show the tree in your solution - text only answer) 3.3 Produce the SQL statement for the query raised at site-C in ‘Given-2' i.e. Site-C query = List Lecturer Id number, Lecturer family name and School name for all lecturers 3.4 Identify the total cost (i.e. transmission + join) for each scenario you can identify in order for site-C to get an answer to its query 3.5 Identify the minimum cost if the same query was raised at site-A and the result sent to site-B and site-C