First page Back Continue Last page Image

2NF – Partial Dependency

In our Cooking Table the Key is RecipeID+IngrOrd
But The Temp field is dependent on the Recipe
I have created a Partial Dependency in the cooking table

RecipeID	RecpName	RecpDescription
102345	Carnitas Bien	Pork Sauteed and Braised
102346	Deep Pit Beef	Covered Time Baked Beef
102347	Moroccan Chicken	Seasoned Baked Chicken

RecipeID	IngrOrd	IngrID	IngrAmt	MixB4Cook	Rest	IngrTime	Temp
102345	01	22	2	Y	N	1	250
102345	02	12	3	Y	Y	1	250
102345	03	16	2	Y	N	1	250

IngrID	IngrName	IngrType	IngrUnits
22	Salt	Sea	Teaspoon
12	Pork	Shoulder	Pounds
16	Cumin	Ground	Tablespoon

Cooking Table

Recipe Table

Ingredient Table