We want to design a database to allow queries of Mountain High RV inventory of new and used RVs. Assume there are three Mountain High RV dealership locations in a region that shares one relational...

We want to design a database to allow queries of Mountain High RV inventory of new and used RVs. Assume there are three Mountain High RV dealership locations in a region that shares one relational database management system (RDBMS).

The basic data fields for each RV include stock number (a common name for SKU (Stock Keeping Unit)), vehicle identification number (VIN), condition (new or used), type (or class), make, model, year, color and price. Identify the possible candidate keys, the likely primary key, probably foreign keys, and potential secondary keys for the Vehicle table. Identify other tables the Vehicle table might need to form a relationship (or link with) to support Mountain High operations.