please answer all questions:

a. create a Database Design solution for the same case study (as shown above)

b. Complete the list of assumptions for all relationships shown in the given solution. You will notice that assumptions have been listed for only one of the relationships to be used as an example.

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

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). ERD: Specialist overseesProductmade ofIngredient is ordered by> is purchased from Customer Vendor 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). ERD: Specialist overseesProductmade ofIngredient is ordered by> is purchased from Customer Vendor