Consider the following mini-world description: A car dealership wants to store information on the types of cars it has. For each type of car it sells, it wants to store a unique identifier, its make and model, and its year. They also want to store its MSRP (i.e. suggested price). 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. Be sure to identify any primary, candidate, and foreign keys in your design. Then write a short explanation (a few sentences per table) justifying your design.