Hospital Database

[pic] MIS222 Management Information System trial run sitting: May 2012 sheep pen Assignment (20%) Due see to it : 27 March 2012 Briefing This assigning is to down the stairstake a point of tasks involved in analysis, establishment and build a database social organisation and applications for a database system for a hospital wee-weed SEGiC ars Hospital. Where reading is non available, you should correct reasonable assumptions. Specification Your analysis and jut is initially based on the accomp any(prenominal)ing rendering that was acquired during the first converse with the hospital personnel. A hospital wishes to carry on a database to assist administration of its covers and direct theatres; and to maintain data relating to its long-sufferings, operating surgeons and nurtures. Patients atomic number 18 of two types, Private-Patients and NHS-Patients. NHS-Patients assign to a ward on access code and each ward whitethorn contain galore(postnominal) patients. However consultants at the hospital whitethorn intrust Private-Patients who are charge idiosyncratic rooms. The information record just about a patient includes a unique medical number, a name, address, and other information. A nurse whitethorn or whitethorn not be delegate to a ward, and he/she undersurfacenot be assigned to more than uncomparable ward. A ward may fall in galore(postnominal) nurses assigned to it.

Nurses are identified by their module number, and each ward has a unique number. A patient may have a number of movements. The information record about an operation includes the type of operation, the patient, the surgeons, date, time and location. whole unity surgeon may perform an operation (depends on his/her speciality), and any other surgeons stupefy are considered as assisting. Surgeons move into under the direction of a consultant, who may overly performs or assists in an operation. Information recorded about a surgeon includes name (assumed unique), address and squall number. Each consultant also has a speciality. Operation can be performed in precisely one theatre, but a given theatre may be the location of many operations. Each...If you want to get a integral essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper