Design a database for a used car lot. The database must be in third normal form. Show the files/tables/stores and the key for each. The data that needs to be kept is:

Car id

Manufacturer

Model

Year

Mileage

Cylinders

Horsepower

Length

Width

Height

Date car acquired at the lot

Cost paid for the car

Asking price

Minimum selling price

Actual selling price

Date when car sold

Id for person who bought the car

Name

Address

Phone

Purchase option used when buying car

When a car is sold, you want to move information from the available file to a file that tells what customers bought, when the bought it, plan they used, what they paid etc.

If you see other information that you feel would be valuable feel free to include it.