<div>
You need a table that sits over the top of Recipe. When building a recipe, one of the attributes of Recipe will be the "type"<br><br>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....<br><br>So, you need to establish all your "types" first, then they can be used to add as an attribute of Recipe.<br><br>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.<br><br>What database are you thinking of ?&nbsp;
</div>


<div>
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].
</div>


<div>
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--&gt;batter--&gt;cake--&gt;baked goods.
</div>


<div>
@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. <br><br>So a table should not track cake, pie, etc. They should be attributes.<br><br>
</div>


Mark01

<div>
Thank you, Brian Crowe, Scott Pletcher and Mark Wills.
</div>


<div>
Our pleasure. I do wish you all the very best for your project. Sounds interesting. And, we are always here to help....
</div>


<div>
<div class="content wysiwyg-content">
This is not a homework question. This question involves defining an entity that includes cake, a type of baked good.<br />
<br />
A cake is a type of baked good. A &quot;Cake Type&quot; entity includes desserts that are ready to eat. Examples of items in this kind of entity are cakes, breads and cookies.<br />
<br />
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.<br />
<br />
The food database already has Recipe and Ingredient tables. Please help me define this entity.
</div>
</div>


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.

Food Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.