Lo scenario
A research database stores clinical, biomarker, genetic, medication, and outcome data for heart disease studies, requiring normalized tables and one-to-many relationships from patients to measurements and events.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
01
Bridge table StudyParticipant to model many-to-many patient-study enrollment
02
Separate Biomarker and BiomarkerMeasurement to normalize test definitions and results
03
Link samples to both patients and studies for traceability
Reusable for any clinical research registry or hospital analytics project that integrates longitudinal patient data with samples and genomic results.