Family Health History Tracking System - EER Diagram
FAMILY_MEMBER
family_member_id
name
date_of_birth
gender
relationship_to_user
blood_type
user_ID
Status
HAS
1
HEALTH_EVENT
M
onset_age
diagnosis_date
condition_name
event_id
severity
notes
status
Constraints
1. Primary Keys:
• FAMILY_MEMBER: family_member_id (PK)
• HEALTH_EVENT: event_id (PK)
3. Domain Constraints:
• onset_age: Must be a non-negative integer (≥ 0)
2. Cardinality and Participation:
• One FAMILY_MEMBER can have many (M) HEALTH_EVENTs
• Every HEALTH_EVENT must belong to exactly one (1) FAMILY_MEMBER
• HEALTH_EVENT has total participation (double line)
• severity: Controlled values {Low, Medium, High}