A bit of automation?
1/ You can do this in a Drupal Webform so that the original coach has their relationship expired

2/ we did some work for another age-based organisation to ensure that only the valid membership type was available based on the Date of Birth. It isn't something that I could just 'share' but if it helps you and you have a bit of budget we could probably extract what you need fairly quickly.