Hospital Database

[pic] MIS222 Management Information System Exam sitting: whitethorn 2012 congregation Assignment (20%) Due date : 27 inch 2012 Briefing This assignment is to down the stairstake a range of tasks mingled 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 honest 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 operating(a) theatres; and to maintain discipline 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(postnominal) patients. Ho wever consultants at the hospital whitethorn hold Private-Patients who are assigned individual rooms. The information record virtually 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 loca tion. yet unity surgeon may perform an op! eration (depends on his/her speciality), and any other surgeons present are considered as assisting. Surgeons fill in 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 tho 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