(PLEASE SEE ATTACHED FOR WORD DOCUMENT CONTAINING DATABASE DETAILS AND FULL DETAILS, THE BELOW INFORMATION IS JUST A SMALL BRIEF. THIS PROJECT NEEDS TO BE COMPLETED WITHIN 2 WEEKS)
Tabsoft is a financial software company which has a number of important clients. On a regular basis, information regarding financial products is sent to the company in the form of an XML feed. This information is then inserted into the internal company database and used within a number of software products.
A system is required to automate this process, reading in the data from the XML feed and loading it directly into the database. The structure of the database is given below. The DBMS Database Management System (DBMS) used by the company is MySQL which is freely available on the internet.
In addition to loading the data, the directors of the company would like a report produced which outlines all of the products found in the XML feed for this month. The format of the report should be HTML so that it can be uploaded to the internal company website.
You are required to:
1. Implement a system using the appropriate technology to produce a report outlining the products available from the distributor this month (see XML feed/document)
2. Implement an XML Schema for the given XML document (see XML feed/document).
3. Indentify a suitable programming language that will read the XML document and insert its contents into the database. You must justify your choice.
4. Create the MySQL database from the structure given below and insert the appropriate data from the XML feed