I am working well (as far as I know) on using foreign keys to create a relational database for products to be sold. A catalog, basically.

My question is related to cars.

My final cars table has a make_id, model_id, list_price, ...

However, I would also like to sell from accessories like spare batteries, cleaning solutions, etc.

Should I make a separate table for accessories?! Or should I somehow incorporate every item that I potentially sell into one table?

It confuses me here a bit, because obviously a battery wouldn't have a make_id, for instance.

Thanks for the tips.

I use mysql.