I’m working on a MySQL question and need guidance to help me study.
- a) Draw an E/R Diagram to model the “recipes†database system, identifying all entity sets, their
attributes, key attributes, and relationships.
A recipe can have one or more “tags†that can be used to identify “meal types†such
as breakfast, brunch, lunch, tea, supper, dinner, or snack. Users can “tag†their recipes anyway
they want. A recipe lists all of its ingredients, each identified by a three-letter code, also having a longer description. For example, “salted butter†might be cataloged in the system as “sbt†with a longer description “Salted Butter.†A recipe must define, for each of its ingredients, the quantity used in the recipe and their unit (cup, teaspoon, tablespoon, grams, pinch, etc.). Finally, a recipe defines a list of steps, each step uniquely identified (within a recipe) by a sequential number accompanied by a short description of the step.