PLEASE CHECK DB DESIGN

D

Dean Welch

The purpose of this database will be to store race results for drag cars,
this will include specifications of the cars setup, engine setup, race
results (including tracks weather info provided on slip at the time of the
race), driver and event . there is normally a drag event 8 times a month and
I want to be able to do a race and record the results on the time slip these
results include,
Race Time (e.g 3:59pm),
TrackTemperature, RelativeAltitude, Milibars, Humidity, AirTemperature,
Reaction, 60ftTime, 330ftTime, 660ftTime, 660ftMPH, 1000ftTime, ElapsedTime,
ElapsedMPH.
I also want to be able to record ,
TyreType, TyreSize, GearBox, DiffRatio, EngineCompression, Carburetor,
FrontJets, RearJets, FuelPressure, BaseTiming, TotalAdvance, TyrePressureHot,
TyrePressureCold, StageRPM, ShiftRPM, so that when i changed the jets in the
carby (or other engine or car specs) between races i know what difference it
made.I also need event info as there are multiple tracks across australia,
car info to be able to identify the car, and driver info so I can keep tabs
on driver and what car they raced at what event and which race at that event.
there could also be different drivers for the same car at the same event,(e.g
i could do a run in my brothers car). The database needs to be setup for
multiple entries (e.g many cars at one event) as many drag racers have shown
an interest, (Thanks to my big mouth brother???)

Main outcomes for the database will be to record a cars race results for a
particular event to keep track of the cars performance, and so that I can
search back through previous races by weather info, and setup the car and
engine the same so that the car keeps running consistent race times, because
the relative altitude, air temp, milibars, race track temp can make a big
difference in the overall race time & mile per hour.

The database has already been built and can be downloaded at

http://www.dfwcomputer.com/db/db1.zip

thanks in advance.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top