drag racing program in sql— help?
Can anybody help me with this? I have no experience at all in sql. I know it’s a long problem, but I don’t even know where to begin.
The goal of the racing class I am in (drag racing) is to travel 1/8 of a mile in EXACTLY 5.800 seconds. The challenge is that many variables impact car performance, the most significant being weather conditions. In order to assist in achieving the target performance goal, a program will be written that tracks these variables. At any given race the racer will be able to enter the current weather conditions and the program will find the settings used to run 5.800 (or whatever was run that pass) when under similar weather conditions.
The first step in this is to create the database and tables. You need to hand in the SQL script to:
1) Drop any existing related database and tables.
2) Create the required database and tables.
3) Set up the appropriate users and permissions.
Here is the list of variables so far, in no particular order:
Date
Track Name
Car number
Elevation
Track condition
Comments
time
dial in
delay box setting
Hit brakes? (just Y/N or hard/light/moderate?)
temperature
relative humidity
barametric pressure
dew point
horsepower correction factor
Density altitude (will be calculated)
pressure altitude
adjusted altitude
grains per pound
vapor pressure
relative air density
relative oxygen density
actual air density
vapor pressure altitude difference
heat index
horsepower (corrected)
wind speed
wind direction
track direction
track temperature
tire temperature
rear tire pressure
front tire pressure
horsepower factor
Launch RPM
change in ET per 100 rpm launch change
Shift RPM
change in ET per 100 rpm shift change
reaction time
60′ time
330′ time
330′ mph
1/8 time
1/8 mph
1000′ time
1000′ mph
1/4 time
1/4 mph
60 – 330
330 – 660
660 – 1000
1000 – 1/4
330 – 1/4
660 – 1/4
margin of victory
nitrous stages
stage 1 nitrous target hp
stage 1 nitrous jets
stage 1 nitrous pressure
stage 1 fuel jets
stage 1 fuel pressure
stage 1 nitrous delay
stage 2 nitrous target hp
stage 2 nitrous jets
stage 2 nitrous pressure
stage 2 fuel jets
stage 2 fuel pressure
stage 2 nitrous delay
opponent name
opponent notes
Repeat all performance data for opponent (in case iCard is available)
throttle stop 1 setting (I dunno squat about throttle stops yet)
throttle stop 1 ratio
throttle stop 2 setting (I dunno why 2 but I saw it somewhere…)
throttle stop 2 ratio
stage (shallow/deep/normal)
converter stall
rear shock setup
front shock setup
Digital 7 program name
Static timing
Launch retard amount
Launch retard duration
2nd gear shift retard amount
2nd gear shift retard duration
3rd gear shift retard amount
3rd gear shift retard duration
4th gear shift retard amount
4th gear shift retard duration
Percent rise
Front suspension travel limit
Rear suspension preload
Front upper 4-link hole number
Front lower 4-link hole number
Rear upper 4-link hole number
Rear lower 4-link hole number
Ladder bar hole number
Spark plug part number
Spark plug source
Spark plug gap
Oil Filter part number
Oil Filter source
Suspension Parts
December 28th, 2009 at 9:12 am
Get discount suspension parts.
yes
December 31st, 2009 at 1:36 pm
Suspension Parts
today i found a piece of grass and pulled it out of the ground. i put it in my pocket for safe keeping. then a rabbit comes at me from behind and, next thing i know, he has my piece of grass. i chased him, but rabbits are fast and i just learned how to walk a few days ago. i finally decided to just find another blade of grass, which only took a few hours because i was in a very grassy area. this time i put the grass in my mouth so no one could steal it.
on my way home, though, i tripped on a rock and accidentally swallowed the grass. instead of finding a new one, i decided to find the one i swallowed. when i got home, i found a spoon and opened up my tummy with it. i guess i waited too long, because the piece of grass wasn’t there. then i realized there was a bunch of red stuff around me and i fell asleep. when i woke up, i was in a hospital. then i woke up again and i was in my bed, at home and my tummy was still closed.
January 3rd, 2010 at 7:08 pm
Get discount suspension parts.
You’re giving us just about nothing of value (variable names and “make a database” are useless) and asking us to do about $3,000 worth of work for you for free. That’s not what this site is for. Write the program and, if you have a specific question, about a specific line, or a few specific lines, of code, post it.