Database Design: how to associate car colors? Associate it to its make or trim? [closed]

Closed. This question is off-topic. It is not currently accepting answers.

---

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 11 years ago.

Improve this question

I'm working on a project that deals with cars. I need to know if a car's color selection is based on the "model" or the "trim." For example, does the "2011 nissan sentra" have a list of available colors for all its 开发者_如何学JAVAtrims? Or does the "2011 nissan sentra LX" have a list of available colors for just that trim (in this example, the "LX") and that other trims would have different color options?

---

I believe it's just called the "trim". For example: http://buyersguide.caranddriver.com/nissan/sentra/price#features

It says there are 5 trim options, even though the next page shows 6, but if you surf around for other cars, the trim numbers usually match up with the color options.

Not necessarily related, but I did also come across this: http://www.paintscratch.com/search.html Use the second search box and try something simple like "red"