Pilgrim Hospital is a reputable private hospital that provides healthcare services. Their patient may receive may different types of services and procedures from the hospital skilled and experienced staff. The following is their scenario: - Patients may be admitted when necessary or may only receive outpatient treatment. Patient data recorded include patient number, name, address comprises of street, city, postcode, state, contact number and administration date. - For outpatient extra information is required is treatment remarks. - For inpatient additional information include date admitted, date discharged, and follow-up date. - Each of this patient is treated by a physician that may either be a senior physician, an attending doctor or a resident doctor. A physician characteristics recorded are physician number, name, contact number and address. Additional characteristic for each of the doctor is as follows: i. A senior physician has a license number and area of specialization. ii. An attending doctor will have license number, qualification and fellowship. iii. As for resident doctor, he or she will have certificate number (doctor-in-training) and area of interest. - When necessary a patient is admitted for further treatment by an attending doctor. An attending doctor may admit many patients whom he or she thinks needed full observation and attention from the physician. - The admitted patient or the inpatient is then assign with bed. Each bed is tracked by bed number, bed ward and bed floor. When this happened the date of bed assignment is recorded. ------------------------------------------------------------------------------------ Illustrate the above scenario by designing the Enhanced Entity Relationship Diagram for Pilgrim Hospital. Please ensure that attributes, relationship, cardinality, participation and discriminator is clearly described.
Pilgrim Hospital is a reputable private hospital that provides healthcare services. Their patient may receive may different types of services and procedures from the hospital skilled and experienced staff. The following is their scenario:
- Patients may be admitted when necessary or may only receive outpatient treatment. Patient data recorded include patient number, name, address comprises of street, city, postcode, state, contact number and administration date.
- For outpatient extra information is required is treatment remarks.
- For inpatient additional information include date admitted, date discharged, and follow-up date.
- Each of this patient is treated by a physician that may either be a senior physician, an attending doctor or a resident doctor. A physician characteristics recorded are physician number, name, contact number and address. Additional characteristic for each of the doctor is as follows:
i. A senior physician has a license number and area of specialization.
ii. An attending doctor will have license number, qualification and fellowship.
iii. As for resident doctor, he or she will have certificate number (doctor-in-training) and area of interest.
- When necessary a patient is admitted for further treatment by an attending doctor. An attending doctor may admit many patients whom he or she thinks needed full observation and attention from the physician.
- The admitted patient or the inpatient is then assign with bed. Each bed is tracked by bed number, bed ward and bed floor. When this happened the date of bed assignment is recorded.
------------------------------------------------------------------------------------
Illustrate the above scenario by designing the Enhanced Entity Relationship Diagram for Pilgrim Hospital. Please ensure that attributes, relationship, cardinality, participation and discriminator is clearly described.
Step by step
Solved in 2 steps with 2 images
