MIS602: The Doctor Either Prescribes Medicine Or Admits The Patient: Data Modelling & Database Design Report, VU, Australia

Description:

In RRH, 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, the entry card of the patient) for check-ups from the relevant doctor. After making entries in the card, they go to the relevant doctor’s room and the doctor checks up on their ailments. According to the ailments, the doctor either prescribes medicine or admits the patient to the relevant department.

The patient may choose either a private or general room according to his/her need. But before getting admission to 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 discharge 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, the management talks about the doctors of the hospital. There are two types of doctors in the hospital, namely, regular doctors and call-on doctors. Regular doctors are those doctors who come to the hospital daily. Call-on doctors are those doctors who are called by the hospital if the relevant regular doctor is not available.