Please help with ERD setup for a sports league
Here is my sport’s scenario:
There are 25 weeks of play. Each week has 8 matches between 2 teams. Each team uses 5 to 7 players per match. Players may play for different teams in different matches.
I need to calculate stats for each player and each team (relatively easy).
How should I set up an ERD for that scenario?
TIA, Larry W.