This CWM 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 check$-$up 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 check$-$up

of patients done by the doctors, the patients that have been operated, and patients

discharged from the hospital. In hospital, there are many departments like Orthopaedic,

Pathology, Emergency, Dental, Gynaecology, Anaesthetics, I.C$.$U$.,$ Blood Bank,

Operation Theatre, Laboratory, M$.$R$.$I., Neurology, Cardiology, Cancer Department,

Corpse, etc. For each department, name, location and facilities available should be

stored. When patient arrives, a patient number is generated. Other details like name,

age, sex, address, city, phone number, entry date, and name of the doctor referred to$,$

diagnosis, and department name are also stored. After storing the necessary details

patient is sent to the doctor for check$-$up$.$ 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. A doctor can check$-$up many patients. A patient can go to any doctor.

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 fulfil 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. When

patient is admitted, his$/$her related details are stored in the database. Information stored

includes patient number, advance payment, mode of payment, room number,

department, date of admission, initial condition, diagnosis, treatment, number of the

doctor under whom treatment is done, attendant name, etc. If patient is operated in the

hospital, his$/$her details are stored in the database. Information stored includes patient

number, date of admission, date of operation, number of the doctor who conducted

the operation, number of the Operation Theatre in which operation wascarried out, type

of operation, patient$$s condition before and after operation, treatment advice, etc.

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. Each doctor is given an identity number starting with DR $($regular$)$ or DC $($on$-$

Page $5$ of $14$

call$)$ prefixes only. For each doctor, doctor id$,$ name, qualification, address, phone

number, address is stored. A regular doctor should have doctor id$,$ salary, and date of

joining stored. An on$-$call doctor will have doctor id$,$ fees per call and payment due

stored.List each potential business rule that might arise from the CWM scenario.