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
Get step-by-step solutions from verified subject matter experts
