Question: Based on the description below, develop an ER diagram using draw.io . Don t forget to denote entities, attributes, and relationships ( including cardinality and

Based on the description below, develop an ER diagram using draw.io. Dont forget to denote entities, attributes, and relationships (including cardinality and modality).
Bob Belcher is putting together a cookbook of his burger recipes. For each of Bobs burgers, he records a unique ID number, name (e.g., Sweet Home Avocado), and a brief description. He also stores a field tracking whether the burger fits any of the following dietary restrictions: Vegetarian, Vegan, Pescetarian, Gluten Free. A burger can meet multiple dietary restrictions (e.g., Pescetarian and Gluten Free), but some burgers do not meet any of these dietary restrictions.
Bob also records information about the ingredients in the burger (e.g., ground beef). All ingredients have a unique ID and name. Ingredients can appear on multiple burgers, but must appear on at least one to be listed in the recipe database. Burgers can be entered into the database before any ingredients have been decided. For each ingredient used in a specific burger recipe, he records the quantity and measurement type (e.g., pounds, cups, teaspoons, etc.). For some recipe ingredients, there is no measurement type. For example, 1/2 avocado is just an ingredient and quantity.
In addition to the burger recipes, Bob is recording suggested beer pairings for each burger in the database. Each burger may have one suggested beer, or may have none, and each beer is suggested as a pairing for at least one burger. The information Bob stores about beers includes a unique ID, name (including the company name and beer name, e.g., Peace Tree Brewing - Blonde Fatale), style (e.g., Ale), and ABV (alcohol by volume).

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 Databases Questions!