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
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.
Step by Step Solution
3.46 Rating (156 Votes )
There are 3 Steps involved in it
Step: 1
The bakery specialists started to plan bread at home in a stove utilizing factories to crush grain i...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started