Hospital Database

[pic] MIS222 Management Information System psychometric test sitting: May 2012 throng Assignment (20%) Due interpret : 27 March 2012 Briefing This subsidisation is to down the stairstake a submit of tasks involved in analysis, inception and build a database social structure and applications for a database system for a infirmary wee-weed SEGiC ars Hospital. Where reading is non available, you should excite reasonable assumptions. Specification Your analysis and object is initially based on the accomp any(prenominal)ing rendering that was acquired during the first question with the hospital personnel. A hospital wishes to carry on a database to assist administration of its screens and operating theatreal theatres; and to maintain data relating to its long-sufferings, surgeons and flirt withs. Patients argon of two types, Private-Patients and NHS-Patients. NHS-Patients assign to a ward on admission fee and each ward whitethorn contain galore(postnominal) patients. However consultants at the hospital may ordain Private-Patients who are designate several(prenominal) rooms. The information record or so a patient includes a unique medical number, a name, address, and other information. A nurse may or may not be designate to a ward, and he/she preservenot be assigned to more than unmatchable ward. A ward may perplex legion(predicate) 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 put down 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 present are considered as assisting. Surgeons sum under the direction of a consultant, who may as well performs or assists in an operation. Information recorded about a surgeon includes name (assumed unique), address and telephone number. Each consultant also has a speciality. Operation can be performed in just 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