The scenario
A single-location dental office needs a logical data model to track patients, appointments, procedures, insurance claims, and payments.
What is in this drawing
Read the decisions behind it.
01
Used separate AppointmentProcedure join table to capture many-to-many between appointments and procedures
02
Modeled insurance claim details as a child table to itemize per-procedure claim amounts
03
Included policy_number on Patient to support per-patient insurance policy details
Reusable for any small clinic or office needing an ER diagram with insurance billing, procedure tracking, and payment reconciliation.
More like this