Food Database
This is not a homework question. This question involves defining an entity that includes cake, a type of baked good.
A cake is a type of baked good. A "Cake Type" entity includes desserts that are ready to eat. Examples of items in this kind of entity are cakes, breads and cookies.
A cake is included in a category of items that include baked breads, cake and cooked rice. A cake can result from a cake mix and cooked rice can result from a package of an instant rice mix.
The food database already has Recipe and Ingredient tables. Please help me define this entity.
A cake is a type of baked good. A "Cake Type" entity includes desserts that are ready to eat. Examples of items in this kind of entity are cakes, breads and cookies.
A cake is included in a category of items that include baked breads, cake and cooked rice. A cake can result from a cake mix and cooked rice can result from a package of an instant rice mix.
The food database already has Recipe and Ingredient tables. Please help me define this entity.
ASKER
The project tracks food planning and preparation. For example, a task report may be the following: measure dry ingredients for cake recipe #1 on 4-1-20. Yes, I have all of the recipes. I need help associating a given recipe with the category. For example, a cake is [category].
ASKER
Here are some more details. Written recipes are used, so there is no need to track all ingredients for any given recipe. Examples of data in the Ingredient table are "carrots" and "sour cream." I need to learn how to design the tables to show the following flow: cake recipe #1-->batter-->cake-->baked goods.
ASKER
@Mark Wills: Your comment: So, you need to establish all your "types" first, then they can be used to add as an attribute of Recipe.
So a table should not track cake, pie, etc. They should be attributes.
So a table should not track cake, pie, etc. They should be attributes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, Brian Crowe, Scott Pletcher and Mark Wills.
Our pleasure. I do wish you all the very best for your project. Sounds interesting. And, we are always here to help....
I guess it is a bit like a cook book. If I go to the Desserts section, I would find a list of desserts, then I could go to the dessert of choice. Once there, I would find all the raw ingredients and instructions....
So, you need to establish all your "types" first, then they can be used to add as an attribute of Recipe.
Can you explain a bit more about your project ? Sounds interesting, and also sounds fairly raw. It sounds like you have all the recipes, and now wanting to build a database to support your project.
What database are you thinking of ?