Hi all
Me and a group of friends meet up and race F1 online every week. Therefore, we run a season 4 times a year that last 3 months (12 rounds).
I'm trying to bring our point scoring system to the modern world. I've never designed a db myself and I'm using this as an excuse to learn.
Basically, the format is for each season we have around 10 drivers and we race 12 tracks.
To start off, I'm thinking that my DB will need to have a table with the driver names and a table with all the tracks available (we mix it up but the table will hold all 26 tracks).
Next up I guess I'll need to have a table with the season data:
which tracks were chosen;
which drivers are in this season.
However, I'm stuck at the next stage. Do I need a table for every race? How do I score keep? For each race in the 12 race league I'd need to give each driver the respective points.
(No need to get into Input methods - for that I am covered).
Any help? Or a nudge to the right forum where I should ask this?
Me and a group of friends meet up and race F1 online every week. Therefore, we run a season 4 times a year that last 3 months (12 rounds).
I'm trying to bring our point scoring system to the modern world. I've never designed a db myself and I'm using this as an excuse to learn.
Basically, the format is for each season we have around 10 drivers and we race 12 tracks.
To start off, I'm thinking that my DB will need to have a table with the driver names and a table with all the tracks available (we mix it up but the table will hold all 26 tracks).
Next up I guess I'll need to have a table with the season data:
which tracks were chosen;
which drivers are in this season.
However, I'm stuck at the next stage. Do I need a table for every race? How do I score keep? For each race in the 12 race league I'd need to give each driver the respective points.
(No need to get into Input methods - for that I am covered).
Any help? Or a nudge to the right forum where I should ask this?