Healthcare Appointment System

CLINIC, APPOINTMENT, AWARENESS_CONTENT Entities

CLINIC USER APPOINTMENT AWARENESS_CONTENT HAS BOOKS (0,N) (1,1) (0,N) (1,1) clinic_id name specialty location appointment_id appointment_datetime (NOT NULL) status (Pending/Confirmed/Cancelled) user_id (FK) clinic_id (FK) content_id description topic Constraints • APPOINTMENT must reference valid USER and CLINIC (FK + total participation) • Total participation: Double lines indicate (1,1) - every appointment MUST have user and clinic • Status: controlled values (Pending/Confirmed/Cancelled) • appointment_datetime: mandatory field (NOT NULL)
Entity
Relationship
Attribute
Primary Key (underlined)
1, M Cardinality

Entity Descriptions

CLINIC: Stores clinic details (name, specialty, location)

APPOINTMENT: Booking records linking users to clinics

AWARENESS_CONTENT: Educational content (standalone)