<SYSTEM_TASK:>
Solve the following problem using Python, implementing the functions described below, one line at a time
<END_TASK>
<USER_TASK:>
Description:
 def name_for_scalar_relationship(base, local_cls, referred_cls, constraint):
 """ Overriding naming schemes. """

    name = referred_cls.__name__.lower() + "_ref"
    return name