We want to export this data into an XML file. Write a schema describing the following structure for the XML file:
- There is one root element called EmployeeData
- The EmployeeData element contains a sequence of Department sub elements, one for each Department in the database
- The Department element contains others sub elements include Id, Name, Equipments, Employees
- The equipments element contain others sub elements include Id, Name, AcquireDate, Price
- The Employees contain a list of Employee in the department. Each Employee’s data store in a Employee element.
- All of Id information of elements are attributes.
Write Schema for XML data, with validation values.