14. The following ERD depicts the logical database design for an online bakery.

Question

14. The following ERD depicts the logical database design for an online bakery. The primary business for this company is cupcakes. However, the owner is more than happy to bake cookies, cakes or pies. This database needs to keep track of customers, employees, orders, the different baked goods she sells along with the ingredients from these baked good. There is a problem with this entity. What is the problem? BAKED GOOD ItemID: VARCHAR [PK ] :VARCHAR VARCHAR stedCost: VARCHAR VARCHAR edient: VARCHAR ondIngredientQuantity: VARCHAR edient: VARCHAR edientQuantity: VARCHAR OA) There is a functional dependency ·B) There is a transient dependency (0) C) BAKED GOOD needs to be turned into a Super type and Sub Type for the different ingredients. D) There is no problem

Explanation / Answer

Answer:)

There is no functional dependecy...so a is not the answer

there is no transient dependency....so b is not the answer

Baked good can be made out of main ingredient as well as secondary ingredient, so making BAKED_GOOD a Super type and main and secondary ingredient as Sub type feels reasonable....so c is the answer. You chose the correct answer.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.