Please make the model as well thanks so much cant wait to upvote!!!

Consider an automobile dealership with three locations. Data fields exist for stock number, vehicle identification number, make, model, year, color, and invoice cost. Identify the possible candidate keys, the likely primary key, a probable foreign key, and potential secondary keys. In particular, your paper should address the following:

• The list of the key entities for that system along with the possible attributes
• Clear identification for the primary/foreign keys for each table
• The complete ER model based on your identified entities
• Make sure to list all of your assumptions to explain the relationships among the entities in your ER model