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 eg 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 eg 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 eg 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 eg pounds, cups, teaspoons, etc. For some recipe ingredients, there is no measurement type. For example, 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, eg Peace Tree Brewing Blonde Fatale style eg Ale and ABV alcohol by volume
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
