** This is a urgent case, bid only if you are willing to do it shortly, thanks **
Using XMLSpy or similar tool to develop an XML Schema to represent the data model for the following application.
Discuss the possible ways to model M:N relationships with XML Schema, and their pros and cons together.
A department has arranged industrial placements for students to work for an external company on approved projects. Firstly, the project tutor writes to companies to ask for projects. Companies reply with an outline project's specification. The projects tutor liaises with the company to obtain detail on the project and makes a decision on whether to approve it or not. A Company may forward many projects and different contact names may be given in each case. Approved projects are collected together and categorized according to speciality (e.g. analysis, design development, and management). The list of approved projects is shown to students and they make a selection to which projects they would like to do. Each student may select up to 3 projects and a project may be selected by up to 3 students. The project tutor then assigns projects to students, trying as far as possible to satisfy choices made.
When students have been allocated to projects, the tutor assigns 2 members of staff to supervise each project. They are the chief supervisor and co-supervisor. The project tutor then writes to the companies to inform them whether or not their project has been selected and if so, of the allocations (student and supervisors) made. The curriculum vita (CV) of the student is also enclosed for allocated project. The chief supervisor must make an initial visit to the company with the student to set project objectives. Also must make a mid-project and end-of-project visit. At the end of the project period, both supervisors must together assess the work carried out based on a submitted report. The project tutor monitors project progress throughout.
The project tutor wishes to computerize the system so that outline project specifications are accessible to students through a central database and so that choices and allocations can be made and publicized within the computerized system. The system should also be able to generate letters and monitor project status.
Consideration is being given as to whether or not the skills required to do the projects should be stored and matched to the skills of the student, given the course that student has fulfilled and their achievement in it.