Decision Support Systems by Vicki L. Sauter

Sample Databases
General Car Data


Databases
| car-sale | classic | cylinder | engine | holdbacks |
| location | maintenance | overview | personal costs | production statistics | world production | state requirements |
| state taxes | sales origin | safety | taxes | top sellers |


1. Car_Sale

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

The data set provides information about the sales of automobiles in general vehicle categories. The fields and their meanings are shown below.
Year
Small: percentage of all vehicles sold that were small vehicles
Midsize: percentage of all vehicles sold that were midsize vehicles
Large: percentage of all vehicles sold that were large vehicles
Luxury: percentage of all vehicles sold that were luxury vehicles


2. Classic

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

The data set provides information about the value of vehicles considered "classics." It includes peak prices, prices in 1995 and the source of the information as summarized in Road and Track. The fields and their meanings are shown below.
Make
Model
Year: of manufacture
Peak Price
Price: in 1994
Source


3. Cylinders

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

The data set provides information about the number of cylinders generally associated with each size of vehicle as summarized in Car and Truck Buying Made Easier. The fields and their meanings are as shown below.
Size: general size of vehicle from mini-compact to full size pickup truck
Three-Cylinder: availability of this option on the size of vehicle
Four-Cylinder: availability of this option on the size of vehicle
Six-Cylinder: availability of this option on the size of vehicle
Eight-Cylinder: availability of this option on the size of vehicle
Twelve-Cylinder: availability of this option on the size of vehicle


4. Engine

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

The data set provides information about the size of engines associated with the number of cylinders as summarized in Car and Truck Buying Made Easier. Displacement is a measure of the volume of the combustion chambers and is expressed in liters. Generally, the greater the volume of the combustion chamber, the greater the power potential for the engine. The fields and their meaning are as shown below.
No_cylinders: number of cylinders
Low_displacement: the bottom of the displacement range typical for that number of cylinders
Hi_displacement: the top of the displacement range typical for that number of cylinders


5. Holdbacks

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

The data set provides information about dealer holdbacks. All American and most European and Asian automakers refund money to the dealer after the car is sold. This amount is usually a function of the manufacturer's suggested retail price (not including destination charge) as summarized in Road and Track. The fields are shown below.
Manufacturer
Percentage Holdback
Additional Information


6. Location

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

The data set provides information on the country in which automobiles are produced as summarized in PM Buyers Guide. The fields and their meanings are shown below.
Make
Model
Country1 - Country 3: three countries in which the greatest number of vehicles of this make and model are manufactured


7. Maintenance

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

The data set summarizes the cost for regular maintenance for automobiles at recommended times in the life of the automobile. The fields and their meanings are summarized below.

Make
Engine
Drive_train
Part_6mo: expected parts costs for 6 month regular maintenance
Labor_6mo: expected labor costs for 6 month regular maintenance
Total_6mo: total expected costs for 6 month regular maintenance
Part_12mo 12 month regular maintenance
Labor_12mo
Total_12mo
Part_18mo 18 month regular maintenance
Labor_18mo
Total_18mo
Part_24mo 24 month regular maintenance
Labor_24mo
Total_24mo
Part_30mo 30 month regular maintenance
Labor_30mo
Total_30mo
Part_36mo 36 month regular maintenance
Labor_36mo
Total_36mo
Part_42mo 42 month regular maintenance
Labor_42mo
Total_42mo
Part_48mo 48 month regular maintenance
Labor_48mo
Total_48mo

8. Overview

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

The data set provides an overview of vehicles in each category as summarized in Car and Truck Buying Made Easier. The fields and their meanings are as shown below.
Size: represents the general size of vehicle from mini-compact to full size pickup truck
EX1 - EX3: three common examples of the kind of vehicle in that size range
Price_Low: the bottom of the price range typical for that size of vehicle
Price_High: the top of the price range typical for that size of vehicle
Attribute1 - Attribute3: three typical attributes of that size of vehicle
Style1 - Style3: provides guidance on categories of vehicles, such as the number of doors, windows and wagon components
Type1 - Type3: provides guidance on the "drive types" available for that vehicle, including front-wheel drive, rear-wheel drive, four-wheel drive
Manual: the kind of options available with standard transmission
Automatic: the kind of options available with automatic transmission
Fuel1 - Fuel2: fuel requirements, e.g., gasoline or diesel
Engine1 - Engine2: the number of cylinders available with that size of vehicle


9. Personal

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

This data set summarizes the personal costs associated with owning an automobile. The fields and their meanings are summarized below.
Year
New_Autos: new autos purchased during year
Net_Used: net used vehicles purchased during year
Other_vehi: net other vehicles purchased during year
Access_Par: total tubes, tires, accessories and parts purchased during year
Repair_Par: total spent on repair, grease/lube, repair, wash, store and rent during the year
Gas_oil: total spent on gasoline and oil during the year
Tolls: total spent on road and bridge tolls during the year
Net_ins: net spent on insurance during the year (minus the premiums paid)


10. Producti

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

This data set summarizes the level of production of automobiles during two years. The fields and their meanings are summarized below.
Make
Model
Prod_92: the amount produced during the 92 model year
Prod_93: the amount produced during the 93 model year


11. Safety

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

The data set summarizes data from the National Highway Traffic Safety Administration as discussed in an article in Kiplinger's. The fields and their meanings are as shown below.
Make of the Automobile
Model of the Automobile
Overall NHTSA Score: Kiplinger's summary safety score. The lower the score, the safer the automobile.
Driver HIC: The driver's chance sustaining a head injury in a crash.
Scores- 500 or less: almost no chance of head injury in a frontal crash at 35 mph.
Score- 1,000 one in 6 occupants may have life-threatening skull injury in a frontal crash at 35 mph.
Passenger HIC: Passengers' chance of sustaining a head injury in a crash.
Insurance Score: Frequency of insurance claims filed based on personal injury protection claims.
under 100: loss is a percentage (amount below 100) less than average
100: average loss
over 100: loss is a percentage (amount over 100) more than average
Restraint System: type of safety restraint system in the car
Other: additional safety restraint system in car



12. Sales_or

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

The data set summarizes the origin (location of manufacturer) of automobiles purchased in the US. The fields and their meanings are summarized below.
Year
Domestic: number of vehicles purchased in the USA and manufactured in the USA
Fr_Japan: number of vehicles purchased in the USA and manufactured in the Japan
Fr_Germany: number of vehicles purchased in the USA and manufactured in the Germany
Fr_other: number of vehicles purchased in the USA and manufactured in countries other than the USA, Japan or Germany


13. State_st

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

The data set summarizes some information about driving by state. The fields and their meanings are summarized below.
State
Gas_tax: amount of tax
Belt_use: state requirements on the use of seat belts
Gal_vehicl: average gallons of fuel used per vehicle
MI_driver: average annual miles driven per licensed driver
Tot_import: total number of vehicles imported for purchase in the US.
Tot_US_Sal: total number of vehicles sold in the US that year


14. Taxes

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

The data set summarizes state-based automobile-related taxes (for states in the USA) as shown in the Almanac. The fields and their meanings are shown below.
State
Title Fee
Registration Fee: average registration fee
RF_Lower: lower end of the range for registration fee
RF_Upper: upper end of the range for registration fee
RF_Comment comments regarding the registration fee
Personal Property Fee: average personal property fee
PP_Lower: lower end of the range for personal property
PP_Upper: upper end of the range for personal property
PP_Comment comments regarding the personal property
Sales Tax Fee: average personal sales tax
ST_Lower: lower end of the range for sales tax
ST_Upper: upper end of the range for sales tax
ST_Comment comments regarding the sales tax
Local Tax Fee: average personal local tax
LT_Lower: lower end of the range for local tax
LT_Upper: upper end of the range for local tax
LT_Comment comments regarding the local tax
Gas Tax Fee: average personal gas tax
GT_Lower: lower end of the range for gas tax
GT_Upper: upper end of the range for gas tax
GT_Comment comments regarding the gas tax
Safety Insp Fee: average safety inspection fee
SI_Lower: lower end of the range for safety inspection fee
SI_Upper: upper end of the range for safety inspection fee
SI_Comment comments regarding the safety inspection fee
Emission Insp Fee: average emission inspection fee
EI_Lower: lower end of the range for emission inspection fee
EI_Upper: upper end of the range for emission inspection fee
EI_Comment comments regarding the emission inspection fee
Comments
Footnotes



15. Top_sell

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

The data set provides information about the top-selling vehicles in individual years. The fields and their meanings are shown below.
Make
Model
Sold: total number of vehicles sold in this category
Position: sales position; a value of "1" is best (top selling automobile in that year); values range to 10 some years and to 20 other years
Year


16. World_Pr

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

The data set provides information about the world-wide production of automobiles. Sales figures for the US and Canada are provided as well as those for Europe and Asia. Other production is grouped together. The fields are as shown below.
Year
USA
Canada
Europe
Japan
Other
World_tot

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