Database Design Sample

[dfwcomputer]

Hi,

Can anyone look at this database design and help me out.The purpose of this database will be to store race results for drag racers this will include specifications of there cars, car setups, engine specs, track conditions and weather conditions. The main people to use this database will be drag racers.

Everyone is free to use or modify the design.


tblEvent
EventID
EventType
EventDate

tblDriver
DriverID
FirstName
LastName

tblCar
CarID
CarMake
CarModel
EngineMake
EngineSize
Gearbox
DiffRatio
TyreType
TyreSize
TyrePressHot
TyrePressCold
CarbyMake
CarbySize
JetsFront
JetsRear
FuelPressure
BaseTiming
TotalAdvance
EngineCompression

tblCarDriver
CarDriverID
CarID
DriverID

tblWeather
WeatherID
RaceTime
TrackTemperature
Milibars
Humidity
AirTemperature

tblResults
ResultsID
CarDriverID
StageRpm
ShiftRpm
Reaction
60ftTime
330ftTime
660ftTime
660ftMph
1000ftTime
ElapsedTime
ElapsedMph
Comments


Any info would be greatly appreciated

 

[KenHigg]

So will this be used to actually track the race results during an actual event, like keeping up with who came in 1st, 2nd, etc. Or are you just going to collect some data to do some type of analysis?

kh

 

[dfwcomputer]

just want to record data so that if i go to a meet i can track the temparature, relative altitude, humidity and the likes from previous meets and then set the car to a similar setup to keep race et's consistent