Hospital Database

[pic] MIS222 Management Information System Exam sitting: whitethorn 2012 congregation Assignment (20%) Due date : 27 bump into 2012 Briefing This assignment is to down the stairstake a range of tasks affect in analysis, institution and build a database structure and applications for a database system for a hospital wee-weed SEGiC ars Hospital. Where reading is non available, you should make apt assumptions. Specification Your analysis and design is initially based on the accomp any(prenominal)ing rendering that was acquired during the first interview with the hospital personnel. A hospital wishes to carry on a database to assist administration of its wards and run theatres; and to maintain entropy relating to its long-sufferings, operating surgeons and nurses. Patients are of two types, Private-Patients and NHS-Patients. NHS-Patients assign to a ward on admission and each ward may contain galore(postnominal) patients. However consultan ts at the hospital may break Private-Patients who are assigned individual rooms. The information record nigh a patient includes a unique medical number, a name, address, and other information. A nurse may or may not be assigned to a ward, and he/she cannot be assigned to more than matchless ward. A ward may have many 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 operations. The information recorded about an operation includes the type of operation, the patient, the surgeons, date, time and location. nevertheless unit y surgeon may perform an operation (depends ! on his/her speciality), and any other surgeons present are considered as assisting. Surgeons practice under the direction of a consultant, who may as well as performs or assists in an operation. Information recorded about a surgeon includes name (assumed unique), address and phone number. Each consultant also has a speciality. Operation can be performed in hardly 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, visit our page: write my paper