Question: Exercise 2 . 2 . A Formula One fan club wants to set up a database to keep track of the results of all the
Exercise A Formula One fan club wants to set up a database to keep track of the results of all the seasons since the first Formula One World championship in
A season is held on a year, between a starting and an ending date, has a number of races, and is described by a summary and a set of regulations. A race has a number stating its order in a season an official name eg Formula One Shell Belgian Grand Prix a race date, a race time expressed
in both local and UTC time a description of the weather when the race took place, the pole position consisting of driver name and time realized and the fastest lap consisting of driver name, time, and lap number
Each race of a season belongs to a Grand Prix eg Belgian Grand Prix for which the following information is kept: active years eg etc. for the Belgian Grand Prix total number of races races as of for the Belgian Grand Prix and a short historical description. The race of a season is held on a circuit, described by its name eg Circuit de SpaFrancorchamps location eg Spa, Belgium type such as race, road, street number of laps, circuit length, race distance the latter two expressed in kilometers and lap record consisting of time, driver, and year Notice that the course of the circuits may be modified over the years. For example, the SpaFrancorchamps circuit was shortened from to km in Further, a Grand Prix may use several circuits over the years, as we the case for the Belgian Grand Prix.
A team has a name eg Scuderia Ferrari one or two bases eg Maranello, Italy and one or two current principals eg Stefano Domenicali In addition, a team keeps track of its debut the first Grand Prix entered the number of races competed, the number of world championships won by constructor and by driver, the highest race finish consisting of place and number of times the number of race victories, the number of pole positions, and the number of fastest laps. A team competing in a season has a full name, which typically includes its current sponsor eg Scuderia Ferrari Marlboro from to a chassis eg F an engine eg Ferrari and a tyre brand eg Bridgestone
For each driver, the following information is kept: name, nationality, birth date and birth place, number of races entered, number championships won, number of wins, number of podiums, total points in the career, number of pole positions, number of fastest laps, highest race finish consisting of place and number of times and highest grid position consisting of place and number of times Drivers are hired by teams competing in a season as either main drivers or test drivers. Each team has two main drivers and usually two test drivers, but the number of test drivers may va
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
