Create an XML database for the records stored in "EMP" table built from the "Insert" statements in the "cretab.sql" file. In addition create a DTD that can be used to validate the table structure and the XML format (i.e., test validate the XML database). The XML document requires the following elements (others may be required also).

- element that represents the entire table

- element that represents an employee record

- element representing the employee number field

- element representing the employee name field

- element representing the employee number field

- element representing the job field

- element representing the employee manager field

- element representing the employee's hire date field

- element representing the employee's salary field

- element representing the employee's commission field

- element representing the employee's department number field

cretabs.sql file:

CREATE TABLE EMP (

EMPNO char(4) NOT NULL,

ENAME text(10),

JOB text(9),

MGR char(4),

HIREDATE DATE,

SAL decimal(7,2),

COMM decimal(7,2),

DEPTNO char(2) NOT NULL,

CONSTRAINT EMP_EMPNO_PK PRIMARY KEY (EMPNO));

INSERT INTO EMP VALUES (7839,'KING','PRESIDENT',NULL,DATE('17-NOV-1981','DD-MON-YYYY'),5000,NULL,10);

INSERT INTO EMP VALUES (7698,'BLAKE','MANAGER',7839,DATE('1-MAY-1981','DD-MON-YYYY'),2850,NULL,30);

INSERT INTO EMP VALUES (7782,'CLARK','MANAGER',7839,DATE('9-JUN-1981','DD-MON-YYYY'),2450,NULL,10);

INSERT INTO EMP VALUES (7566,'JONES','MANAGER',7839,DATE('2-APR-1981','DD-MON-YYYY'),2975,NULL,20);

INSERT INTO EMP VALUES (7654,'MARTIN','SALESMAN',7698,DATE('28-SEP-1981','DD-MON-YYYY'),1250,1400,30);

INSERT INTO EMP VALUES (7499,'ALLEN','SALESMAN',7698,DATE('20-FEB-1981','DD-MON-YYYY'),1600,300,30);

INSERT INTO EMP VALUES (7844,'TURNER','SALESMAN',7698,DATE('8-SEP-1981','DD-MON-YYYY'),1500,0,30);

INSERT INTO EMP VALUES (7900,'JAMES','CLERK',7698,DATE('3-DEC-1981','DD-MON-YYYY'),950,NULL,30);

INSERT INTO EMP VALUES (7521,'WARD','SALESMAN',7698,DATE('22-FEB-1981','DD-MON-YYYY'),1250,500,30);

INSERT INTO EMP VALUES (7902,'FORD','ANALYST',7566,DATE('3-DEC-1981','DD-MON-YYYY'),3000,NULL,20);

INSERT INTO EMP VALUES (7369,'SMITH','CLERK',7902,DATE('17-DEC-1980','DD-MON-YYYY'),800,NULL,20);

INSERT INTO EMP VALUES (7788,'SCOTT','ANALYST',7566,DATE('09-DEC-1982','DD-MON-YYYY'),3000,NULL,20);

INSERT INTO EMP VALUES (7876,'ADAMS','CLERK',7788,DATE('12-JAN-1983','DD-MON-YYYY'),1100,NULL,20);

INSERT INTO EMP VALUES (7934,'MILLER','CLERK',7782,DATE('23-JAN-1982','DD-MON-YYYY'),1300,NULL,10);