Crafted with EdrawMax, this ER diagram outlines a hospital management system. Key entities include *Doctor* (with attributes like Doctor_ID, Specialization), *Nurse* (Nurse_ID, shift timings), *Patient* (Patient_ID, contact details), *Appointment* (scheduled by doctors), *Medicine* (prescribed by doctors), and *Payment* (made by patients). Relationships are clearly mapped: nurses “assist” doctors, doctors “treat” patients and “prescribe” medicine, patients “makes” payments. Each entity’s primary keys (PK) and foreign keys (FK)—like Appointment_ID linking to Doctor_ID/Patient_ID—ensure data integrity. This diagram serves as a blueprint for designing database structures in healthcare systems, clarifying entity interactions and data flow.
