I would like to design a database for Recipes. The table structure should be able to support information about the recipe such as its name, who wrote the recipe and when, as well as the recipe’s ingredients, ingredient quantities (and unit), and directions. How many tables I need for the Recipe database and what would be the relationships?
I have the following tables so far but I need a good database design for the Recipe's and the data types as well?
(1) Recipe Table
[RecipeID] [RecipeName] [RecipeAuthor] [RecipeDirections]
1 Happy Toast Andrew butter on bread, then toast bread, etc.
(2) Table Ingredients
(3) Table RecipeIngredients
[RecipeID] [IngredientID] [IngredientDirections]
1 1 (toast needs butter)
1 2 (toast needs bread)
Could you tell me is there anything missing in the above database for Recipe's?
Thanks for your help. Looking forward to your reply.