Relational database - normalization assignment:
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:
Date car acquired at the lot
Cost paid for the car
Minimum selling price
Actual selling price
Date when car sold
Id for person who bought the car
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.