Hi there i have been asked to normalise this problem to 3NF:

Cooking(rID, rname, (ingredientID, ingredientName, amount), cookID, cookName, cookPhNumber);

These are the functional dependencies:

cookID -> cookName

cookID -> cookPhNumber

rID -> rname

rID -> cookID

ingredientID -> ingredientName

The solution that i have come up with is as follows:

Cooking(rID, rname)

Cooks(cookID, cookName, cookPhNumber)

Ingredients(ingredientID, ingredientName, amount)

Im just wondering if this is correct?

Thanks