Question: Please draw the Entity-Relationship Diagram, including the entity types and relationship types (including attributes), for the following scenario. A recipe database system would like to

Please draw the Entity-Relationship Diagram, including the entity types and relationship types (including attributes), for the following scenario. A recipe database system would like to conserve recipes from various chefs. One chef can create many recipes and only one chef can be the original creator of a recipe. Only the data of chefs who invent at least one recipe are kept in the database. Each chef is described by his/her first name, last name, specialty, and title(s), assuming no two chefs have the same combination of first name and last name. For each recipe, an ID number (unique), the name, preparation time, cook time, and occasion(s) are recorded. Ingredients are used in different recipes; only the ingredients used in at least one recipe would be kept in the database. A recipe can possibly use any number of ingredients. When an ingredient is included in a recipe, the quantity should also be documented. For each ingredient, the name, season(s), main color, and category are logged in the system. The recipe may have been included in some cooking books already. Each book is described by the International Standard Book Number (ISBN), the main title, the subtitle, and the publish date.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!