Draw an entity-relationship diagram for the following situation: A commercial bakery makes many different products. These products
Question:
Draw an entity-relationship diagram for the following situation: A commercial bakery makes many different products. These products include breads, desserts, specialty cakes, and many baked goods. Ingredients such as flour, spices, and milk are purchased from y Sometimes an ingredient is purchased from a single vendor, and other times an ingredient is many vendors. The bakery has commercial customers, such as schools and restaurants, that regularly place orders for baked goods. Each baked good has a specialist that oversees the setup of the bakery operation and inspects the finished product. dors. The commercial bakery entity-relationship diagram is shown below. Note that the bakery itself included as an entity, since there would not be a file of bakeries.
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi