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).

You are required to:

1) Complete the attached Entity-Relationship Diagram (ERD) using the above case study. Two entities are missing. All minimum and maximum cardinalities are missing.

2) Draw your ERD solution in the Dia program (Use ER tools).

3) Include minimum and maximum cardinalities for each relationship shown in the ERD, using the Dia program.