Scenario - Clinic Management System

One hospital has many clinics. A clinic has a number of doctors who work in it. Doctors are specialists in some branch of medicine(e.g. cardiology, neurology, orthopaedics, etc.) and can be associated with many patients. A Clinic hosts a number of patients.A data model is illustrated below for your reference. You need to design a system based on the following facts:

a. A clinic has several doctors (DoctorName, Specialisation, etc.)

b. A doctor has a license ID which uniquely identifies him or her (LicenselD, DoctorName, etc.)

c. A doctor has many patients (PatientID, PatientName, Phone, etc.)

d. Each doctorbelongs to a certain category(i.e. medical specialist or general medicine)

e. Depending upon the category, the consultation fee varies.

Create database tables for the scenario above. You must name your tables with your ID as part of the table name: e.g. if your ID is 123456 you would name the tables as follows: clinic table "clinic123456", doctor table "doctor123456", patient table "patient123456". Your entity classes will have a name that reflects yourlD. Failure to do so will result in the assignment being marked as failed.

You are required to develop both a JavaEE application and simple Java client application that perform the following functions. Your webpage should be interactive and attractive.

1. Create a main page with appropriate hyperlinks

2. Createclinic, doctorand patientrecords

3. Add doctors to a clinic

4. Add new patients to a clinic

5. Update/Editclinic, doctors and patients

6. Delete clinic, doctor and patient

7. List all clinics, doctors and patients

8. List the doctors and patients of a particular clinic by id and name.

9. Change the category of a doctor (from general medicine to medical specialjsto vice versa).

10. Create a function that will compute the consultation fee of a doctor with the following criteria:

If a doctor's category is general medicine, the patient will be charged with the regular rate.

If adoctor's category is medical specialist, the patient will be charged double.

11. List the doctor (DoctorlD, Name, Specialisation) + patients that they have (Patient10, Name) +total patients per doctor. One request is enough to accomplish this function.

12. Transfer patients between doctorswith the same clinicotherwise it is not allowed to make such a transaction.