Hi everyone, I'm planning a database of 25 years' worth of racing results and would like some help with the layout and concept before I make a start on it.
In short, it needs to list the results of every practice session, qualifying session and race at each event this racing series held since it began. I'd also like to be able to list the riders who competed at each one, details of the circuits raced at and a few other things, as well as being able to search the results and compile statistics for each rider and circuit. It's pretty comprehensive in theory but I could use some help getting started.
At the moment I'm a bit stuck on how to assign points scored. Rather than creating a new field in the results, is it possibly to automatically assign points to the top 15 riders in each race? I'd also like to be able to add up total points scored by each rider in a year and compile championship totals for each season.
Any help and feedback would be greatly appreciated.
What's stored in the Session table? It looks like a simple reference table, but then it has date values in it too.
What are the natural keys for each table? Its ok to use surrogates (I put them on all my tables), but you also need to define a natural key within the data (one or more columns) and define that as unique.
If it's not practically useful, then it's practically useless.