Design ER Diagram of the following HMS situation: Patients, doctors, nurses and departments are the key constructs of Hospital Management System. Every patient has a unique PatientID, a FirstName and LastName, DateOfBirth, Gender (can be male or female), must have multiple ContactNumber, Address and Email. A patient can consult one or more doctors and each doctor has a unique DoctorID, a FirstName and LastName, Specialization, ContactNumber, Email. A doctor can have many patients. There are nurses to work with doctors, each nurse has unique NurseID, a FirstName, a LastName, Department, ContactNumber, Email, one or more nurses can work with many doctors and each nurse is associated with only one department.
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.