• I am struggling to understand how your diagram shows any relationships.

    Is it simply a statement of facts about people?

    Does the presence of a row in the HandHygiene table mean that the person either did or did not comply with hand hygiene rules?

    Would your fact table look something like this?

    DelegateID INT,

    ReportDate DATE,

    HasConflictResolutionEvent TINYINT,-- (1 - YES, 0 = NO)

    CompliesWithHandWashing TINYINT,

    CompliesWithInfectionControl TINYINT,

    CompliesWithViolenceAggression TINYINT,

    HasMentalCapacityTraining TINYINT,

    etc.

    With Dimensions:

    Date

    Division/Department/Role/Delegate