Reference no: EM131584972
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.
|
Dedicated application-specific firewall
: Give the pro's and con's and describe what situation each of your chosen firewalls is best for.
|
|
Discuss levels of assurance that can provide on audit report
: Discuss the levels of assurance that can be provided on audit reports. Explain how the internal controls of a company can impact the overall business.
|
|
Complete the excel worksheet as required in audit program
: The sales journal, sales orders, shipping documents, invoices and price list are available on in canvas. Complete excel worksheet as required in audit program
|
|
Discuss evolving theme of awareness regarding discrimination
: Discuss evolving themes of awareness regarding discrimination and the social divide that separated/separates Black US citizens from White US citizens.
|
|
Riders from various countries
: 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
|
|
How much did her company pay for the blood pressure cuffs
: A central supply clerk ordered 14 blood pressure cuffs. After 8% tax and $8.65 shipping, how much did her company pay for the blood pressure cuffs?
|
|
How much is magdalena basis in the inventory received
: When Magdalena's outside basis is $58,000, she receives a liquidating distribution of $15,000 cash, How much is Magdalena's basis in the inventory received
|
|
Vb coding language to decribe the process
: Please use VB coding language to decribe the process
|
|
Display all columns from the faculty and course tables
: Use Select and appropriate joins to display all columns from the Faculty and Course tables for each Faculty and Course in the FacultyCourse table.
|