Issue found: surgeon_id → surgery_type created a transitive dependency since each surgeon always performs the same surgery type. Staffing: General Medicine has the most doctors (52), followed by ...
streak INTEGER NOT NULL DEFAULT 0, longest_streak INTEGER NOT NULL DEFAULT 0, last_completed_at TIMESTAMPTZ, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW( ...