Reference no: EM132295519
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.
4) Insert your ERD solution diagram (from Dia) into a Word document.
5) For each Entity, at least 4 attributes should be listed, where one attribute is identified as the key attribute. This information should be typed in the Word document.