The request
“Create a hospital ERD with Patient, Department, Doctor, Appointment, and Prescription tables, their shown fields and keys, and the stated department, appointment, and prescription relationships.”
Then tryAdd a Billing table.Add room assignments.
What is in this drawing
Read the decisions behind it.
01
Appointment is the central junction entity linking Patient and Doctor — avoids a direct many-to-many.
02
Prescription is 0..N per appointment (many-optional) because not every appointment results in a prescription.
03
Department is separated from Doctor to allow reassignment and normalize specialty data.
Add Room, Ward, and Billing tables for a full HIS schema; add an Admission table for inpatient workflows.
More like this