Hospital Database

[pic] MIS222 Management Information System Exam sitting: whitethorn 2012 congregation Assignment (20%) Due date : 27 show 2012 Briefing This assignment is to down the stairstake a range of tasks complex 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 reasonable 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 in operation(p) theatres; and to maintain selective information 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 whitethorn contain galore(postno minal) patients. However consultants at the hospital whitethorn give Private-Patients who are assigned individual rooms. The information record closely 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, da te, time and location. all unity surgeon ! may perform an operation (depends on his/her speciality), and any other surgeons present are considered as assisting. Surgeons fall down under the direction of a consultant, who may too 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