I have created a database to hold information about a tennis club.
It holds players details, and then has seperate tables to hold information about competitions.
Each player has a unique ID, and so do each of the competitions.
The players can be in up to 4 competitions, and I have it so that...