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.

Kindly answer it. I need it urgently. Please

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 oversees * Product made * Ingredient is ordered by is purchased from Customer Vendor