I am trying to create a database to store details relating to darts matches. Im relatively new to this so was wondering if the design I've come up with below would work. It seems I have lots of places referencing the Player table, is this necesary?
I would look at it in what the most common queries are going to be for the database. That way I don't have to do alot of joins to get my results.
Something like this just playing with it:
With my most common queries probably being Player information and how that player did each turn. Then query the matches and who was the winning player per match and then maybe results for each set.
Just my thoughts.
|show 1 more comment|