Your task is to develop a database for a large-scale (commercial) baking plant. Currently, the plants baking recipes are kept in a collection of separate text files, one such file for each recipe.

A typical recipe file includes the following information: recipe number (assigned by the plant), product name, total number of products (e.g., bread rolls) that the recipe makes, work time required to prepare these products, total time required to make these products (baking and all other necessary work included), equipment required, ingredients used, and directions to follow (list of recipe steps).

To help the planning of plant operations and materials purchasing, you will transfer this kind of information to a relational database. Each recipe makes one product, but there may be several different recipes for the same product, making different quantities, using different procedures, or requiring different ingredients. All ingredients are always measured in the same units; for example, flour, sugar, salt or butter quantities are measured in pounds. You need to keep track of how much of each ingredient is in each recipe, and what pieces of equipment each recipe uses.

Design a database to hold all the above listed information. You do not have to enter any data or create forms in Access, just work on your answer sheet.

1. Create an ER diagram. To do this, you can use in MS Word the option Insert -> Shapes. (12 points)

2. Create a database design outline; you can introduce synthetic keys as needed. (18 points)