Hospital Database

[pic] MIS222 Management Information System Exam sitting: whitethorn 2012 congregation Assignment (20%) Due date : 27 border 2012 Briefing This assignment is to down the stairstake a range of tasks intricate in analysis, institution and build a database structure and applications for a database system for a infirmary wee-weed SEGiC ars Hospital. Where reading is non available, you should make valid 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 direct theatres; and to maintain instruction relating to its long-sufferings, surgeons and nurses. Patients are of two types, Private-Patients and NHS-Patients. NHS-Patients assign to a ward on admission and each ward whitethorn contain galore(postnominal) patients. However consult ants at the hospital whitethorn intrust Private-Patients who are assigned individual rooms. The information record somewhat a patient includes a unique medical number, a name, address, and other information. A nurse whitethorn or whitethorn 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 l ocation. unless unity surgeon may perform! an operation (depends on his/her speciality), and any other surgeons present are considered as assisting. Surgeons pick out under the direction of a consultant, who may similarly 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 solitary(prenominal) 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