Input
files for Project
Following are the four input data files for Project and the order in which the data are stored in
each data files
- Car Input file: car.dat
- manufacturer (string)
- model name (string)
- color (string)
- whether the car is
front wheel drive (FWD), rear wheel drive (RWD), or all wheel drive (AWD)
(string)
- whether the car has
been sold (Y/N). (character)
- listed price (decimal
number)
- year the car was built
(integer)
- number of miles on the
odometer – that is the miles driven (integer)
- a car identity number
(a positive integer that is unique for every car that has ever been in
the system). This number is generated by the database when the record is
created, it is not entered by the user. (unique positive integer)
- Customer Input file: customer.dat
- first name (string)
- last name (string)
- street address
(string)
- town (string)
- state (string)
- zip code (string)
- customer id (a
positive integer that is unique for every customer who has ever been in
the system)
- Sales Record Input file: sales.dat
- the car id number
- the salesperson id
number
- the customer id number
- the actual sale price
- the date of the sale
(string)
- sales record id (a
positive integer that is unique for every sales record that has ever been
in the system)
Last
modified: May 08, 2003.