This ER diagram represents a hospital management system. A patient can schedule one or many appointments when a doctor can have none or many appointments available. The system schedules an appointment with exactly one doctor. The system applies one payment to exactly one patient and one patient can make several payments. The patient pays their receipt with none or several payments. One paid receipt can generate one appointment.

Hospital management system

Hospital management system diagram code in Gleek

DOCTOR
APPOINTMENT
PAYMENT
PATIENT
RECEIPT
DOCTOR ||-is scheduled-o> APPOINTMENT
APPOINTMENT <|-schedules-|| PATIENT PATIENT ||-does-o> PAYMENT
RECEIPT ||-pays-o> PAYMENT
RECEIPT ||-generates-|| APPOINTMENT

About ER diagrams

We often make an entity-relationship (ER) diagram, ERD, or entity-relationship model, in the early stages of designing a database. An ERD is perfect for quickly sketching out the elements needed in the system. The ERD explains how the elements interact. ER diagrams can be shared with colleagues. Their simplicity makes them ideal even for non-technical stakeholders.

Similar ER diagram examples

Online store entity-relationship diagram

Simple order process entity-relationship diagram

Store sales system entity-relationship diagram