I need to design a relational database to handle the following:
A bicycle race, the Tour de Florida, which will have riders from various countries. Each rider will also be on a team. The teams will have a name, a sponsor, and a country. The riders on any given team may be from any country, not necessarily the same as the team country. The overall race consists of a number of stage races, each with a name, date, start and end points, and total distance. Each stage will also have a type (mountain, sprint, time trial ...) I need to create a table for stage types. I need to store the results of each stage, so I need times for each rider in each stage. I need to have enough information to determine the overall winner based on lowest cumulative time, the team with the lowest cumulative time, and overall young rider winner (the rider under a certain age with the lowest cumulative time).
I will need whatever tables that have the riders, teams, stages, and the results of each stage race. I can start out with the needed basic tables but it gets a little confusing to me as we move into the levels, times, etc.
I always have trouble knowing how to connect tables and what those key tables need to be. I am looking for guidance on what tables to create and what info to include.