Risk Alerts & Analysis System
«Health Event History»
FAMILY_MEMBER
member_id
first_name
last_name
user_ID (FK)
gender
status
date_of_birth
relationship
contact_phone
medical_history
HAS_EVENT
1
HEALTH_EVENT
M
event_id
event_date
event_type
severity
diagnosis
symptoms
treatment
outcome
RECEIVES
1
DERIVED
FROM
1
ALERT
alert_id
risk_level
alert_type
priority
status
resolved_date
description
created_date
member_ID (FK)
M
M
Constraints
1. Domain Constraints:
• status ∈ {Active, Resolved}
• risk_level ∈ {Low, Moderate, High}
2. Structural Constraints:
• Every ALERT must be associated with exactly one FAMILY_MEMBER (via RECEIVES)
• ALERT has total participation in RECEIVES and DERIVED_FROM (double lines)
• Each ALERT is derived from exactly one Health Event History aggregation (1:M)