Refer to Chapter 9 in the systems analysis book, do the following:

Think of an automobile dealership with three locations. Data fields exist for stock number, vehicle identification number, make, model, year, color, and invoice cost. Create a table with those data items. Place 3 records in the table. Identify the possible candidate keys, the likely primary key, a probable foreign key, and potential secondary keys.