User Account

All Pages

Riders from various countries

Assignment Help Business Economics
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.

Reference no: EM131584972

Questions Cloud

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.

Reviews

Write a Review

Business Economics Questions & Answers

  By what percent will the wage rate of native workers fall

Some estimates are that immigration has increased the US labor force by 10%. Assume that the labor supply native and immigrant workers are both completely inelastic. By what percent will the wage rate of native workers fall? By what percent of GDP wi..

  Using iterated elimination of dominated strategy

Using iterated elimination of dominated strategy (IEDS), find the equilibrium of the game below:

  Pricing strategies associated with cooperative equilibrium

Two firms, 1 and 2, individually choose and simultaneously submit a bid price for a given product. They can submit either a high price or a low price. If both firms bid high, the resulting payoff for each firm is $80 million. Identify the pair of pri..

  Economics professor to become a gold professional

Ben quit his job as an economics professor to become a gold professional. He gave up his $30,000 salary and invested his retirement fund of $50,000 (which was earning 10 percent interest) in this venture. After all expenses, his net winnings were $35..

  When a recession generates unemployment

When a recession generates unemployment, it is considered: At the national economy level, technological development can generate:

  Differences between process explanations and instructions

Differences between process explanations and instructions. Describe the differences between the two types of documents.

  Econ class about the history of europe

This is for an econ class about the history of Europe. The answer should be about a paragraph long.

  What is hyperinflation

What is hyperinflation? Explain some factors that were responsible for the Zimbabwean hyperinflation of the late 2000s. In 2009, Zimbabwe ended its hyperinflation by adopting the U.S. dollar as legal tender. What potential problem(s) could this strat..

  Student assistant for an engineering firm

You are working as a student assistant for an engineering firm and are paid by the hour. Every two weeks, you turn in a time sheet to your supervisor, and three workdays later, your paycheck is direct deposited into your checking account.

  Describing the current state of the health care

Write a short (2-3 page, double-spaced, typed) essay identifying and describing the current state of the health care industry using the tools we have studied this semester.

  Schematic representation of the organization of the economy

In the circular-flow diagram, the schematic representation of the organization of the economy.

  Most important economic areas

Identify (what you consider to be) the 10 most important economic areas (listed on dismal) that best describe the current state of the U.S. economy. Discuss each one of these measures, focusing on its importance, what it says about the current st..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd