The best songwriters, singers and music biz personalities started out as daughters, sisters and nieces