Decision Support Systems by Vicki L. Sauter

Sample Databases
New Car Data - 1995


Databases: | financial | options | origin | overall | restraints | safety | size | specs | warranty |


1. FINAN

| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

This database describes the financial information about the vehicles. The fields and their meanings are shown below.
MAKE
MODEL
SRP: suggested retail price
DEALER_COS: dealer's cost
TARGET_PRI: buyer's target price
DEST_CHG: average destination price
OPT/RET: options as a percentage of the retail price
RESALE: estimated resale value (after 5 years)
MPG-C: miles per gallon for city driving
MPG-H: miles per gallon for highway driving
INSUR_COST: estimated average cost of insurance
MAINTENANC: estimated 5-year cost of regular maintenance
REPAIRS: estimated 5-year cost of repairs
TOTAL COST: estimated 5-year cost of ownership


2. OPTIO

| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

This database describes the options available on the automobiles. The fields and their meanings are shown below.
MAKE
MODEL
ENGINE_SIZ: size of the engine
TRANSMISSI: type of transmission (standard equipment)
SUSPENSION: type of suspension (standard equipment)
STEERING: type of steering (standard equipment)
WHEELS: type of wheels (standard equipment)
RADIO: kind of radio (standard equipment)
DRIVE: standard drive type (front-wheel drive; rear-wheel drive; four-wheel drive)
BRAKING_SY: type of brakes available standard
FRONT_BRAK: type of front brakes available standard
REAR_BRAKE: type of rear brakes available standard
TIRES: standard tires
EXHAUST_SY: standard exhaust system
AB_AVAIL: availability of airbags (none; standard; extra)
AB_COST: cost of airbag
AC_COST: cost of air conditioning
AUTOMATIC: cost of automatic transmission
R_DEFOGGR: cost of rear window defogger


3. ORIGI

| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

This database details the origin of the model of automobile. The fields and their meanings are shown below.
MAKE
MODEL
ORIGIN: country in which automobile is produced


4. OVERA

| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

This database provides some overall information about the automobiles. The fields and their meanings are shown below.
MAKE
MODEL
NHTSA: safety score; the lower the score, the safer the automobile.
OVERALL: overall evaluation of the automobile
RELBLITY: general reliability of the automobile
SIZE: vehicle category
LAST_REPOR: date of the last Consumer Reports evaluation
COMMENTS: details of the last Consumer Reports evaluation


5. RESTR

| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

This database summarizes the types of restraints available in the automobile. The fields and their meanings are shown below.
MAKE
MODEL
DR_RESTRAI: type of restraint available in driver, front-seat
PASS_RESTR: type of restraint available in passenger, front-seat


6. SAFET

| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

This database summarizes some of the safety issues associated with each automobile. The fields and their meanings are shown below.
MAKE
MODEL
LENGTH of the automobile
WIDTH of the automobile
HEIGHT of the automobile
BRAKING_SY: type of standard braking system
AB_AVAIL: availability of air bags
AB_COST: cost of air bags
NHTSA: safety rating; the lower the score, the safer the automobile
OVERALL: overall Consumer Reports evaluation of safety
RELBILITY: reliability of the automobile
FR_DAMAGE: amount of damage expected to the front end of the automobile in a collision at 35 mph.
RE_DAMAGE: amount of damage expected to the rear end of the automobile in a collision at 35 mph.
AB_DRI: availability of air bag for driver
AB_PASS: availability of air bag for passenger


7. SIZE

| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

This database summarizes size information associated with the automobile. The fields and their meanings are shown below.
MAKE
MODEL
NO DOORS: number of doors
TRUNK: trunk type
CONVT: availability of convertible roof
CURB_WEIGH: weight of the vehicle without passengers or cargo
WHEELBASE: distance between wheels
LENGTH of the automobile
WIDTH of the automobile
HEIGHT of the automobile
FR_LEGROOM: amount of leg room in the front seat
BA_LEGROOM: amount of leg room in the back seat
HEADROOM: average amount of headroom in automobile
CARGO: cubic feet of cargo vehicle can carry


8. SPECS

| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

This database outlines some of the specifications of the automobile. The fields and their meanings are shown below.
MAKE
MODEL
LENGTH of the automobile
WIDTH of the automobile
HEIGHT of the automobile
WHEELBASE: length of axle
WEIGHT of the automobile
FUEL_CAPAC: number of gallons
BASE_ENGIN: size of the standard engine in the vehicle
TRANSMISSI: type of transmission standard with the vehicle
SUSPENSION: type of suspension standard with the vehicle
STEERING: type of steering standard with the vehicle
WHEELS: type of wheels standard with the vehicle
RADIO: type of radio standard with the vehicle
DRIVE: dive type standard with the vehicle
BRAKING_SY: braking system standard with the vehicle
FRONT_BRAK: front brakes standard with the vehicle
REAR_BRAKE: rear brakes standard with the vehicle
TIRES: tires standard with the vehicle
EXHAUST_SY: exhaust system standard with the vehicle


9. WARRA

| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

This database provides information about the warranty associated with the vehicle. The fields and their meanings are shown below.
MAKE
MODEL
BUMPER/BUM: The bumper to bumper (all inclusive) warranty. Both the warranty years and warranty miles are given (separated by a /).
POWERTRAIN: The power train warranty of the vehicle. Both the warranty years and warranty miles are given (separated by a /).
RUSTTHROUG: The external, rusting warranty associated with the vehicle. Both the warranty years and warranty miles are given (separated by a /).


URL: http://www.Wiley.com/college/~Sauter/data/des95.htm
Page Owner: Vicki Sauter (SAUTER@UMSLVMA.UMSL.EDU)
Last Modified: March 13, 1997