$(6$ marks$)($Drawing an ERD$)$

A recipe indicates how to prepare a particular type of food. Each recipe has a recipe name,

a list of $1$ or more ingredients $($with a quantity for each$),$ plus textual instructions.

Here is an example recipe:

Peanut Butter Oatmeal Cookies

Instructions:

Bring butter to room temperature. Preheat oven to $350.$ Beat sugar, brown sugar and butter

until well mixed. Add eggs, vanilla, and baking soda. Mix well. Add peanut butter and mix. Stir

in oats. Cover cookie sheets with parchment paper. Place teaspoons of dough about $2$ inches

apart. Bake for $10-12$ minutes until lightly brown around the edges.

Draw an entity relationship diagram $($ERD$)$ that represents a database for storing such

recipes. Assume ingredients can be stored in your database even if they are not used in any

recipe. Each ingredient can be used in zero or more recipes. Each recipe includes a single

block of text for the instructions.

Use the style of diagram presented in class. Include in your diagram:

Entity, relationship, and attribute names.

Appropriate cardinalities on both ends of each relationship.

Define a primary key for each entity. Put the notation $"($PK$)"$ after each attribute that is

part of a primary key.

Use the notation $"($FK$1)","($FK$2)"$ etc. after each attribute that forms a foreign key.

Make sure the relationships and foreign key attributes are consistent with each other.

$($You can put the PK and FK information before or after the attribute names $-$ it doesn't

matter which$)$

Use the space provided on the next page to draw your ERD.