def get_view_name(sis_term_id, week, label):
    """
    Returns DB view name for the given sis_term_id, week, and view label.

    :param sis_term_id:
    :type str: sis-term-id to create view for
    :param week:
    :type int: week number to create view for
    :param label: label for view.
        Choose from (assignments, participations, or rad)
    :type str:
    """
    if label not in ["assignments", "participations", "rad"]:
        raise ValueError(f"Unknown DB view label {label}. "
                         f"Choose from (assignments, participations, or rad).")
    sis_term_id = sis_term_id.replace("-", "_")
    view_name = f"{sis_term_id}_week_{week}_{label}"
    return view_name