Formula 1 Database

[dantheman10]

I am a big Formula 1 fan and I am thinking about creating a F1 database. However, I can't decide which is the best way to store the data. I don't know if one race should be a one field or if one driver for one season should be one field. Obviously I want to store it in the best way possible so that I can easily pull out relevant data in queries. My knowledge of Access is relatively limited so any help you could give me would be appreciated.

 

[grnzbra]

One table for deivers, one table for races (Indy500, WatkinsGlen, Sebring etc - don't know if these are F1 races, but they are races). Then join them with a join table. That way you can get multiple racers racing in multiple races.

So you would have

Racers
1.....Moss.....Sterling (Is my age showing or what?
2.....Stewart.Jackie
etc

Races
1.....Indy500
2.....Sebring
3.....WatkinsGlen

RaceRacers
Race.....Racer.....Year
1..........1...........2005
1..........2...........2005
2..........2...........2005
3..........1...........2005
1..........1...........2006
2..........1...........2006
2..........2...........2006
3..........1...........2006
3..........2...........2006

 

[Ron_dK]

I would set up four tables, Team, Circuit, Driver and event.
The event table has relationships to the team, driver and circuit.
In the event form ( based on event query) you could enter data per race., including details of teams, drivers, etc.
I have attached a sample which is far from perfect or completed, but just to give an idea of how I would set up this F1.
The ultimate goal is to get an overall standing list per driver and per team.

Hth

Note :
Now that Schumi has left the F1 scenery it will be less fun to say the other hero's perform.

 

[ColinEssex]

This question is also posted in the general section.

Col