Product Management

Database

Which entities do you need?

---

Ingredient

contains the ingredients of the product with a id, name, amount, picture_name, price

• ingredient_id [NUMBER] PK
• name [VARCHAR]
• amount [NUMBER]
• picture_name [VARCHAR]
• price [NUMBER (mit 2 Kommastellen)]

---

Product

= Pizza, which contains id, name, price, picture_name

• pizza_id [NUMBER] PK
• name [VARCHAR]
• picture_name [VARCHAR]
• price [NUMBER (mit 2 Kommastellen)]

---

ProductIngredients

Ingredients on Pizza - solve M-N Relationship (both attributes are a combined PK)

• pizza_id [NUMBER] FK
• ingredient_id [NUMBER] FK

---