Dealership wants to store information on the cars it has. For each type of car it sells, it wants to store a unique identifier, make and model, price, and its year. They also want to store a table that keeps track of the inventory. For each type of car, they need to keep how many of each color they have in stock. Develop an appropriate schema to store this data. Show exactly how the inventory would be tracked. Be sure to identify any primary, candidate, and foreign keys in your design.