요청 내용
“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.”
그렇다면Add a Billing table.Add room assignments.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
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.