You have been hired to design a database for this small bakery. The bakery creates all of their products, on site, daily and sells the products in the same facility through a portion of the site being the store front for the bakery. As the business continues to grow, they are in need of a system to help support their business

1) Some of our customers are walk-in; we dont maintain them in a table. Our larger customers place regular/daily orders with us for events. We do keep customer information on these customers.

2) Each of our customers order any number of baked goods from us. Some order the same product and quantity on a regularly-scheduled basis, others change all the time.

3) We have a large pantry where we store all of the ingredients that we use in our pastries. We call these our raw materials, since each recipe will combine different volumes and combinations of these to produce a finished good, which is our line of pastries and baked goods.

4) Each of our baked goods includes any number of ingredients in their respective recipe.

5) We deal with vendors with whom we have an established relationship. Each of these vendors supplies us some of the ingredients that we use in our baked goods.

LIST ALL ENTITIES, AND WRITE ALL BUSINESS RULES THAT DICTATE THE RELATIONSHIPS BETWEEN ALL OF THE ENTITIES.

IF POSSIBLE, INCLUDE SCREENSHOT OF COMPLETED ERD (VISIO)