I am using a graph database for the first time for a project - I'm creating this for free for a non profit organisation but I am taking the opportunity to learn Neo4j and graph database modelling at the same time.
Basically a league system, with seasons and several division. In the end of the season top teams will advance up to a higher division and bottom teams will go to lower divisions.
This is my initial design and I have realize that this will unfortunately not work very well between seasons. I been trying to search for similar models to get inspiration but have not found any relevant yet. I got so many questions that I stumble on trying to get this right! Should I use intermediate nodes more or should I use edges to arrange the model? Looking maybe a few years down the line the model could be very cluttered.
So, any experienced modeler out there that have some good tips?