“Draw an ER diagram for inpatient medication administration with Patient, Admission, Medication, MedicationOrder, and Administration tables. Orders must link to an admission and medication, and administrations must link to an order.”
看懂背後的決策。
Admissions link patients to a unit and admission time.
Medication NDC is unique in the formulary table.
MedicationOrder carries dose, route, and status.
Administration records each dose time and nurse identifier.
One order can have many administrations.
This model supports a basic eMAR design. Production medication systems need clinician identity, verification, allergy, interaction, and audit controls.
常見問題
Why record each administration separately?
One order may result in multiple doses, each with its own time and outcome.
What is an NDC?
A National Drug Code identifies a specific drug product in the U.S.
Can a patient have several admissions?
Yes. The Patient-to-Admission relationship supports many stays over time.