A commercial bakery makes many different products. These include breads, deserts, specialty cakes, and many other baked goods. Ingredients such as flour, spices, milk, and so on 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. (Taken from Kendall and Kendall, 1999).

Use ERD solution shown below in order to compile a Database Design solution for the same case study (as shown above).

Complete the list of assumptions for all relationships shown in the given solution.

Use the given entities and attributes in order to compile a database design with listed reasons.