Design ER Diagram of the following HMS situation: Patients, doctors, nurses and departments are the key constructs
Fantastic news! We've Found the answer you've been seeking!
Question:
Regular Doctor’s OPDs are scheduled by hospital in which a doctor has many appointments and one patient has one or more appointments as well having unique AppointmentID, PatientID, DoctorID, Date, Time, Status. HMS also maintaining a medical record of every patient with unique MR#, PatientID, DoctorID, Date, Diagnosis, Treatment, each patient can have multiple medical records. Hospital is composed of many departments and every department has unique DepartmentID, DepartmentName, HeadOfDepartment and HOD must be adoctor. A department can have multiple beds each has a unique BedID, BedNumber, Ward, Availability and a bed belongs to one department. A patient has to make payment against every availed service and can make multiple payments
with unique PaymentID, PatientID , Amount, PaymentDate, PaymentMethod. Create an Entity Relationship diagram that captures this information. Be certain to indicate
identifiers and cardinality constraints.
Related Book For
Operations Management Processes And Supply Chains
ISBN: 9781292409863
13th Global Edition
Authors: Lee Krajewski, Naresh Malhotra, Larry Ritzman
Posted Date: