A restaurant in California has hired a lot of top chefs. Each has several signat

Question

A restaurant in California has hired a lot of top chefs. Each has several signature dishes. The conceptual schema below is a simple complete conceptual schema with attribute details. Let us assume that it is correct. Please review the methods for systematically converting a conceptual schema to a logical schema in class and see if the above table schemata (structures) are correct. Please: (a) Point out one error in the above logical database schema and please describe it clearly (b) Explain why this is an error (s) and please explain in more than one or two sentences, (c) Give the correct table structures that fix the error Please label your answers((a), (b), and (c)) clearly. Thank you very much. To answer this particular question, click the link above. Once you are in the forum, click the "Create Thread" button to view the question again, as well as, create and submit your answer.

Explanation / Answer

Hi,

Ans a) The error that I see in this table structure is that there is one additional attribute that is present in the CHEF table. The additional attribute name is "RecipeCreationDate".

Ans b) This attribute "RecipeCreationDate" is extra in CHEF table is because this attribute is logically not related to CHEF. This atribute should be in "CREATES" table.

Ans c) Below is the listof correct table structures-
CHEF(CheFID, ChefName,ChefHiredDate,RecipeID)
SIGNATURE_DISH_RECIPE(RecipeID,DishName, IngredientList,MethodDescription)
CREATES(ChefID,RecipeID,CreationDate)

Regards,

Vinay Singh

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---