A commercial bakery makes many different products. These products include breads, desserts, specialty cakes, and many other baked goods. Ingredients such as flour, spices, and milk are purchased from vendors. Sometimes an ingredient is purchased from a single vendor, and other times an ingredient is purchased from 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.
Case Study 2:
A commercial bakery makes many different products. These products include breads, desserts,
specialty cakes, and many other baked goods. Ingredients such as flour, spices, and milk are
purchased from vendors. Sometimes an ingredient is purchased from a single vendor, and other
times an ingredient is purchased from 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.
Exercise:
1. Draw an entity-relationship diagram for the above situation.
2. List the tables and keys that are needed to implement the commercial bakery system.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
