Design an er schema for hospital management systems

Assignment Help Operation Management

Reference no: EM132219076

Assignment: Design an ER schema for the following Hospital Management Systems, and draw an ER diagram for that schema. Specify key attributes of each entity type and structural constraints on each relationship type. Note any unspecified requirements, and record any assumptions to make the specification complete.

Aim: XYZ hospital is a multi-specialty hospital that includes a number of departments, rooms, doctors, nurses, compounders, and other staff working in the hospital. Patients having different kinds of ailments come to the hospital and get checkup done from the concerned doctors. If required they are admitted in the hospital and discharged after treatment.

The aim of this case study is to design and develop a database for the hospital to maintain the records of various departments, rooms, and doctors in the hospital. It also maintains records of the regular patients, patients admitted in the hospital, the checkup of patients done by the doctors, the patients that have been operated, and patients discharged from the hospital.

Description: In hospital, there are many departments like Orthopedic, Pathology, Emergency, Dental, Gynecology, Anesthetics, I.C.U., Blood Bank, Operation Theater, Laboratory, M.R.I., Neurology, Cardiology, Cancer Department, Corpse, etc. There is an OPD where patients come and get a card (that is, entry card of the patient) for check up from the concerned doctor. After making entry in the card, they go to the concerned doctor's room and the doctor checks up their ailments. According to the ailments, the doctor either prescribes medicine or admits the patient in the concerned department. The patient may choose either private or general room according to his/her need. But before getting admission in the hospital, the patient has to fulfill certain formalities of the hospital like room charges, etc. After the treatment is completed, the doctor discharges the patient. Before discharging from the hospital, the patient again has to complete certain formalities of the hospital like balance charges, test charges, operation charges (if any), blood charges, doctors' charges, etc.

Next we talk about the doctors of the hospital. There are two types of the doctors in the hospital, namely, regular doctors and call on doctors. Regular doctors are those doctors who come to the hospital daily. Calls on doctors are those doctors who are called by the hospital if the concerned doctor is not available.

Reference no: EM132219076

Questions Cloud

One of the key outcomes of successful sale : Which one of the items below is not one of the key outcomes of a successful sale?

What does cellular layout contribute to lean production : Explain the meaning of process capability and the process capability index. What does a cellular layout contribute to lean production?

Middle-of-the-road management best describes leaders : Middle-of-the-road management best describes leaders who are

Specific relationship between leader and each subordinate : Which of the following leadership theories emphasizes the specific relationship between the leader and each subordinate?

Design an er schema for hospital management systems : Design an ER schema for the following Hospital Management Systems, and draw an ER diagram for that schema.

The availability and provision of healthcare services : Differentiate between the availability and provision of healthcare services. How can you as a health care manager facilitate access for patients?

Is the ISPS Code voluntary or mandatory security initiative : Is the ISPS Code a voluntary or a mandatory security initiative? Which types of food products can set off a radiation alarm at a port?

Important steps in the strategic sourcing process : There are 6 important steps in the strategic sourcing process. Select one of the six steps that you consider the most important and explain why.

Was bill an employee or an independent contractor : Was Bill an employee or an independent contractor? Validate your answer from the text and case law.

User Account

All Pages