|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
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'd like to do multiple tables and use normalization. Although I have never made databases that have more than 1 or 2 tables.
Would all the tables be included in a form and would how would I manipulate it so that one record would appear as one drivers race/season, or all the drivers in one race etc. 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. |
|
#2
|
|||
|
|||
|
you'd need one table to store just the races and assign a autonumber field as well i.e.
1 Germany 2 Japan 3 UK etc then one table to store all the drivers names i.e. 1. R Schumacher 2. J Button etc and then finally a table which stores the race id, the position finished and the driver id i.e. Race ID, Position, Driver ID 1, 1, 1 1, 2, 5 1, 3, 3 1, 4, 2 1, 5, 4 etc |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Database Development > F1 Database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|