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.

 

SophiaPretty

(5)

Status NEW Posted 09 Nov 2017 06:11 AM My Price 8.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer