xml to mysql conversion

* Create a DTD based on the following examples and validating them o [login to view URL] o [login to view URL] o [login to view URL] o [login to view URL] o [login to view URL] o [login to view URL] * Create a MySQL database schema to store the information provided by the above XML files * Create php code to import the sample data into the schema. Language is PHP, tests use phpunit3 and xdebug. ## Deliverables A1) Complete and precise implementation of the description of the bid request. A2) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. A3) Deliverables must be in ready-to-run condition, as follows: a software installation package that will install the software in ready-to-run condition for Debian GNU/Linux. A4) The software package source form must be suitable for the debuild command, be lintian clean and install properly with pbuilder. A5) The software installation package must be provided with the first status report and updated for each status report. A6) Buyer will receive exclusive and complete copyrights to all work purchased. Third party software may be included as long as they are published under a license compatible with the GNU GPL. A7) Software must obey the GNU coding standards as found at [login to view URL] A8) Software must be platform and os independent. A9) Software must be provided with a mercurial repository initialized when the work started A10) The work must be commited under mercurial on a daily basis. A11) The reason for each change (not the change itself) must be explained in the ChangeLog file at the root the package tree. ---------------------------------------------------------------------- R1) A set of unit tests covering 100% of the code written or modified for the job. There is no need to cover the code that already existed and that was not modified. R2) a single command without argument must run all the unit tests, report the total percentage of coverage and list all the lines of code (either python, c, c++ or java) that are not covered. R3) Implement a verbose mode for running the tests so identifying which unit test fails and why is straightforward. ## Platform GNU/Linux