Tables and Relations... some advice please

[arif]

Hi,
I am again with this database. I am using Access 2007. I saw and read
Recipe database in Access. But I wanted to make Databasebut little
Different.
Recipes are for Dishes (Food making), DISHES are of Periticular
CUISINES, cuisine may be countrywide, Global or regional and Country
wide. Recipe usually originated from one part of that country.
Then either it stayed as local, regional or beacme popular. and then
modern time Global or we can say International.
I created Tables as follow....

tblDishes..........(pk Dishes auto,DishName,DishDescription,DishImage,Veg y/n,
Method Memo,DishOrigin)
tblDishIngredients.(DishIngredID pk auto,DishId fk,IngredientID fk,Quantity int,
MeasureID fk,Comment memo)
tblIngredients.....(IngredientID pk Auto,IngredientName,AlternateName)
tblCountryCuisines.(CountryID pk auto,DishId fk,CountryName,Cuisine,CusineType,
Note txt)
relations...
tblDishes 1:M tblDisingredients
tblDishes 1:M tblCountrycuisines
tblMeasures is lookup table
tblIngredients is also lookup table
I kept Method as Memo field so one can write complete instructions stepwise.
Dish can be prepared different ways. with same Ingredients or different
Ingredients.

are these tables Normalize...?
After making Input form.. I want some short of command which can Increase
or decrease serving and ingredients ... but original Dish should not be altered.
My reason that if dish serves for 5 or 6 people increasing serving...
All ingredient may not be proportional. Only way think of this calculations
dish should be adjusted to only one serving and then Increase number of
serving. (otherwise spices and condiment may become to high)
any input, comment or suggestions please..

Edit: Also if Dish Images Made into separate Folder how I attach that Image in
Access Table.

Khalakmu

View attachment KRecipesV002UA.zip

 

[rzw0wr]

Khalakmu,
Attached is my view of how the tables should be related.
The tables themselves looked pretty good.

View attachment KRecipesV002UA.zip

Dale

 

[arif]

Thanks Dale appreciate,

tblDishIngredients you named it DishInformation.

In my db tblIngredients is basic Ingredients required for Recipes. So this table
is sort of lookup table for recipes. Quantity and comment is for each ingredient
taken for that recipe.
I vision Recipe form and ingredient sub form (Datasheet view)
Even if tblDishingredients changed to Dishinformation ok but than IngredientID
should be foreign key in Dishinformation table.
Country Table relating to Dishes look right. Here again Same Dish could be in many Country cuisines exactly same ingredients and quantity. so dishes and Countrycuisines relates 1:M.
I do not know How to attach Photo or Image of dish in tblDishes.

Thanks million.