Recipe database design advice


I have a problem designing my database. I have to make a table witch contains let's say a Recipe. I have tables that contain let's say: Spices, Meats, Veggies.

Okay now I need to get data from the Spices, Meats, Veggies and create a recipe in the Recipes table. My question is how to map all of these into the recipes considering that one recipe can have more veggies, more types of meet and more spices.

Thanks.


Answers:


Meat, vegetables and spices are ingredients, IngredientType (M,V,S) is used to identify each group.

enter image description here

If for some reason you feel that each ingredient needs its own table because they have different columns, then use this model. Keep all common columns in the Ingredient table.

enter image description here