Avatar of Mark01
Mark01Flag for United States of America asked on

Food Database

This is not a homework question. This question involves defining an entity that includes cake batter, the result of mixing the ingredients in a given recipe resulting in a variety of batters.

Mixing the ingredients in a cake recipe results in producing cake batter. Cake batter is part of some sort of "Type" entity. This "type" entity includes various batters and doughs.

Here is some sample data: cake recipe #1 batter was frozen on 3-1-2000.

The food database already has Recipe and Ingredient tables. Please help me define the entity.
DatabasesMicrosoft AccessMicrosoft SQL Server

Avatar of undefined
Last Comment
Mark Wills

8/22/2022 - Mon
SOLUTION
John Tsioumpris

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Mark01

I'm having a hard time associating cake batter with a given recipe. Some sample data is shown:
Recipe: cake recipe #1

Batter doesn't seem to be an attribute of the Recipe table. It seems like a linking table with RecipeID foreign key with the batter category name would work. Any thoughts?
Mark Wills

It is like a BOM (bill of materials), an Assembly made from ingredients.

You say you have an ingredients table, so this is in between Recipe (being the end product) and Ingredient (being Raw materials).

So, "batter" will become a mix of raw materials (flour, eggs, milk etc) and become the usable part in the Recipe in place of (or a shortcut to) the raw materials themselves. Having said that, It can always be expanded back into the raw materials list if needed. Each "batter" would have deviations of quantities / ingredients etc. So, you need to build that table as a new beast.

When building a recipe (as the end product), you could choose "batter" or bypass that and go straight to raw materials. It depends on how sophisticated you want to get.

Not sure what the correct term would be in a kitchen (it is a type of recipe when you think about it, just not the finished item).... But will have a few thoughts.
SOLUTION
ste5an

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Mark01

Your comments are very helpful. There is no need to associate ingredients with cake batter. The important association is a recipe with cake batter.

A linking table may be appropriate. The database already Freezer and Shelf tables to track the location of recipes in the freezer.

Fields:
RecipeID (FK)
FreezerID (FK)
Batter (boolean)
Dough (boolean)
Freeze date
 
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Mark01

Thank you, ste5an, Mark Wills and John Tsioumpris.
Mark Wills

Our pleasure. Hope your project works out for you without too many frustrations. Always think about the data. How it relates to each other. All the best....