Decision Support Systems by Vicki L. Sauter

Sample Databases
General Car Data

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

1. SAFETY

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 1 MAKE Character 15 N
2 2 MODEL Character 25 N
3 3 ALT_MODEL Character 15 N
4 4 OVERAL_SCO Character 15 N
5 5 DRIVER_HIC Character 9 N
6 6 PASS_HIC Character 13 N
7 7 INS_SCO Character 15 N
8 8 RESTR_SYS Character 15 N
9 9 OTHR_SAF Character 12 N




2. OVERVIEW

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 SIZE Character 26 N
2 EX1 Character 11 N
3 EX2 Character 15 N
4 EX3 Character 15 N
5 PRICE_LOW Character 9 N
6 PRICE_HIGH Character 10 N
7 ATTRIBUTE1 Character 11 N
8 ATTRIBUTE2 Character 20 N
9 ATTRIBUTE3 Character 24 N
10 STYLE_1 Character 29 N
11 STYLE_2 Character 12 N
12 STYLE_3 Character 12 N
13 TYPE_1 Character 12 N
14 TYPE_2 Character 18 N
15 TYPE_3 Character 18 N
16 MANUAL Character 18 N
17 AUTOMATIC Character 12 N
18 FUEL_1 Character 12 N
19 FUEL_2 Character 9 N
20 ENGINE_1 Character 9 N
21 ENGINE_2 Character 22 N




3. ENGINE

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 NO_CYLIND Numeric 14 N
2 LOW_DISPL Numeric 17 N
3 HI_DISPL Numeric 18 N




4. CYLINDERS

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Field Type Width Dec Index
1 MAKE Character 15 N
2 MODEL Character 21 N
3 NHTSA Character 15 N
4 OVERALL Character 15 N
5 RELBLITY Character 11 N
6 SIZE Character 9 N
7 LAST_REPOR Character 13 N
8 COMMENTS Character 72 N




5. LOCATION

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 MAKE Character 14 N
2 MODEL Character 25 N
3 COUNTRY_1 Character 11 N
4 COUNTRY_2 Character 11 N
5 COUNTRY_3 Character 9 N




6. CLASSIC

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 MAKE Character 15 N
2 MODEL Character 25 N
3 YEAR Character 12 N
4 PEAK_PRICE Character 12 N
5 PRICE_NOW Character 12 N
6 SOURCE Character 9 N


7. HOLDBACKS

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 MODEL Character 15 N
2 PER_HOLD Character 14 N
3 ADD_INFO Character 50 N




8. CAR-SALE

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 YEAR Character 9 N
2 SMALL Character 9 N
3 MIDSIZE Character 9 N
4 LARGE Character 9 N
5 LUXURY Character 9 N


9. FINANCES

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 MAKE Character 10 N
2 HOLD1 Character 2 N
3 MODEL Character 12 N
4 NO_DOORS Character 5 N
5 HOLD_2 Character 2 N
6 TRUNK_SPA Character 10 N
7 CONVERT_AV Character 10 N
8 SRP Character 10 N
9 HOLD3 Character 2 N
10 EST_DLR_CO Character 10 N
11 HOLD4 Character 2 N
12 TARGET_PRI Character 10 N
13 EST_RESALE Character 10 N
14 INS_INDEX Character 10 N
15 DEST_CHRGE Character 10 N
16 OPTIONS_PE Character 10 N
17 HOLD5 Character 2 N
18 RESALE_5YR Character 10 N
19 HOLD6 Character 2 N
20 MPG_CTY_ST Character 10 N
21 MPG_CTY_AU Memo 10 N
22 MPG_HWY Memo 10 N
23 CURB_WT Character 10 N
24 WHEEL_BASE Character 10 N
25 HOLD7 Character 2 N
26 MAIN_5YR Character 10 N
27 HOLD8 Character 3 N
28 REPAIR_5YR Character 8 N
29 HOLD9 Character 2 N
30 TOTAL_5YR Character 10 N
31 ENGINE Character 15 N
32 CYLINDERS Character 8 N
33 HORSEPOWER Character 10 N
34 LENGTH Character 8 N
35 WIDTH Character 8 N
36 HEIGHT Character 8 N
37 LEG_FRONT Character 10 N
38 LEG_BACK Character 10 N
39 HEAD_ROOM Character 10 N
40 CARGO_SPAC Character 8 N
41 REST_PASSI Character 10 N
42 A_LK_BRK_R Character 10 N
43 A_LK_BRK_D Character 10 N
44 AUTO_RETAI Character 10 N
45 AUTO_DEALR Character 10 N
46 A_C_RETAIL Character 10 N
47 A_C_DEALER Character 10 N
48 FUEL_TANK Character 10 N
49 TRANSMISSN Character 20 N
50 SUSPENSION Character 20 N
51 STEERING Character 25 N
52 WHEELSG_CO Character 20 N
53 STD_RADIO Character 25 N
54 STD_DRIVE Character 20 N
55 STD_BRAKE Character 25 N
56 STD_REAR Character 20 N
57 STD_FRONT Character 20 N
58 STD_TIRES Character 31 N
59 STD_EXHAUS Character 20 N
60 AIR_BAG_AV Character 10 N
61 AIR_BAG_CO Character 10 N
62 A_C_COST Character 10 N
63 AUTO_COST Character 11 N
64 DEFOGR_COS Character 10 N
65 NHTSA_EATG Character 10 N
66 OVERALL Character 10 N
67 CR_PDCTBTY Character 11 N
68 CR_FRO_DAM Character 10 N
69 CR_REAR_DM Character 10 N
70 AIR_BAG_DR Character 10 N
71 AIR_BAG_PS Character 10 N
72 SIZE Character 10 N
73 LAST_REPRT Character 13 N
74 COMMENTA Character 10 N
75 COMMENTS Character 65 N





10. WORLD_PR

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 YEAR Character 9 N
2 USA Character 9 N
3 CANADA Character 9 N
4 EUROPE Character 9 N
5 JAPAN Character 9 N
6 OTHER Character 9 N
7 WORLD_TOT Character 14 N




11. TOP_SELL

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 MAKE Character 11 N
2 MODEL Character 16 N
3 SOLD Character 9 N
4 POSITION Character 9 N
5 YEAR Character 9 N




12. TAXES

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 STATE Character 14 N
2 TITLE_FEE Character 12 N
3 REG_FEE Character 12 N
4 RF_LOWER Character 14 N
5 RF_UPPER Character 14 N
6 RF_COMMENT Character 14 N
7 PRSNL_PROP Character 14 N
8 PP_LOWER Character 14 N
9 PP_UPPER Character 14 N
10 PP_COMMENT Character 14 N
11 SALES_TAX Character 14 N
12 ST_LOWER Character 14 N
13 ST_UPPER Character 14 N
14 ST_COMMENT Character 14 N
15 LOCAL_TAX Character 14 N
16 LT_LOWER Character 14 N
17 LT_UPPER Character 14 N
18 LT_COMMENT Character 14 N
19 GAS_TAX Character 14 N
20 SAFTY_INSP Character 14 N
21 SAFET_LOWR Character 14 N
22 SAFET_UPPR Character 14 N
23 EMISSN_INS Character 14 N
24 EMISN_LOWR Character 14 N
25 EMISN_UPPR Character 14 N
26 COMMENTS Character 14 N
27 FOOTNOTES Character 14 N




13. STATE-ST

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 STATE Character 14 N
2 GAS_TAX Character 9 N
3 BELT_USE Character 16 N
4 GAL_VEHICL Character 25 N
5 MI_DRIVER Character 33 N




14. STATE_TAX_S

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 STATE Character 14 N
2 TITLE_FEE Character 12 N
3 REG_FEE Character 12 N
4 RF_LOWER Character 14 N
5 RF_UPPER Character 14 N
6 RF_COMMNTS Character 20 N
7 PERS_PROP Character 14 N
8 PP_LOWER Character 14 N
9 PP_UPPER Character 14 N
10 PP_COMMENT Character 14 N
11 SALES_TAX Character 14 N
12 ST_LOWER Character 14 N
13 ST_UPPER Character 14 N
14 ST_COMMENT Character 14 N
15 LOC_TAX Character 14 N
16 LT_LOWER Character 14 N
17 LT_UPPER Character 14 N
18 LT_COMMENT Character 14 N
19 GAS_TAX Character 14 N
20 SAFETY Character 14 N
21 SAF_LOWER Character 14 N
22 SAF_UPPER Character 14 N
23 EMISSION Character 14 N
24 EMISS_LOW Character 14 N
25 EMISS_UPP Character 14 N
26 COMMENTS Character 30 N
27 FOOTNOTES Character 80 N




15. SALES_OR

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 YEAR Character 9 N
2 DOMESTIC Character 11 N
3 FR_JAPAN Character 11 N
4 FR_GERMANY Character 15 N
5 FR_OTHER Character 16 N
6 TOT_IMPORT Character 14 N
7 TOT_US_SAL Character 16 N




16. MAINTENANCE

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 MAKE Character 30 N
2 ENGINE Character 16 N
3 DRIVE_TRAI Character 12 N
4 PART_6MO Character 11 N
5 LABOR_6MO Character 11 N
6 TOTAL_6MO Character 11 N
7 PART_12MO Character 11 N
8 LABOR_12MO Character 11 N
9 TOTAL_12MO Character 11 N
10 PART_18MO Character 11 N
11 LABOR_18MO Character 11 N
12 TOTAL_18MO Character 11 N
13 PART_24MO Character 11 N
14 LABOR_24MO Character 11 N
15 TOTAL_24MO Character 11 N
16 PART_30MO Character 11 N
17 LABOR_30MO Character 11 N
18 TOTAL_30MO Character 11 N
19 PART_36MO Character 11 N
20 LABOR_36MO Character 11 N
21 TOTAL_36MO Character 11 N
22 PART_42MO Character 11 N
23 LABOR_42MO Character 11 N
24 TOTAL_42MO Character 11 N
25 PART_48MO Character 11 N
26 LABOR_48MO Character 11 N
27 TOTAL_48MO Character 11 N
28 TOTAL_4YR 15 N




17. PERSONAL

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Name Field Type Width Dec Index
1 YEAR Character 9 N
2 NEW_AUTOS Character 10 N
3 NET_USED Character 21 N
4 OTHER_VEHI Character 20 N
5 ACCESS_PAR Character 29 N
6 REPAIR_PAR Character 41 N
7 GAS_OIL Character 10 N
8 TOLLS Character 18 N
9 NET_II Character 25 N


18. PRODUCTI

| view data descriptions |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |

Number Field Field Type Width Dec Index
1 MAKE Character 11 N
2 MODEL Character 15 N
3 PROD_92 Character 11 N
4 PROD_93 Character 11 N


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