Table Design
I am designing a food database. The purpose of the database is to maintain the data used to track the dates on which meals, snacks, etc. were made. A snack can be a left over meal plus a single ingredient. I only need help with some table names. I am not working on the field names yet. Please comment on the proposed tables.
Here are the tables:
Books
Ingredients
Meals
Recipes
Snacks
Here are the tables:
Books
Ingredients
Meals
Recipes
Snacks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A snack can be a left over meal plus a single ingredient.In general "food service" terms, this is to broad...
If a snack can be a "Meal" + an ingredient, ...then it is really a "meal".
(or are we talking about partial or leftover meals?)
How can you call a full meal (Meat, Veg, Starch) plus another ingredient (Ice cream, ...for example), ...a "Snack"?
As the two experts above ave stated, ....you really need to iron all of this out first.
A snack can be a left over meal plus a single ingredient....and what else can a snack be...?
You need to clearly define what a Meal, snack, ingredient is:
A Meal?
A meal + an ingredient?
an ingredient alone?
Up to two ingredients?
What about things like a bag of potato chip? (since this is not a meal, or an ingredient, ...is it still a "snack")
You need to clearly define what each entity is and if it can contain other entities...
So perhaps you could give us more detail please?
Thanks
JeffCoachman
ASKER
Jeff, I appreciate your comments. My statement about a snack being composed of a meal plus an ingredient was incorrect. I meant that a snack can be composed of a quantity of a leftover recipe plus another ingredient. I am not explaining this well so here is an example. A snack can be 2 cups of fruit salad and 1 tablespoon of ice cream.
My goal of this question was to check to see if I was on the right track with the early formation of the entities. The question was answered in 20 minutes. I was surprised that I received excellent answers so quickly.
My goal of this question was to check to see if I was on the right track with the early formation of the entities. The question was answered in 20 minutes. I was surprised that I received excellent answers so quickly.
...ok great...
;-)
;-)
ASKER