Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

1 1 Bakery recipes: Currently, recipe information is kept in a collection of word processing les, one le per recipe. A typical file might look like...

What does the ER diagram look like? Also where does the many to many relationship go? Thank you.

7.1 1 Bakery recipes: You have been hired to help operate a commercial bak—ing plant. Currently, recipe information is kept in a collection of wordprocessing files, one file per recipe. A typical file might look like this: Recipe #801Product Name: Whole grain rolls (product code WGRl)Recipe Makes: 800Work Time: 2 hoursTotal Time: 10 hoursEquipment: Standard sifter (SIFOOl)Heavy-duty mixing machine {MlXOOZ}Kneadingirising machine (KRMOIO)High-temperature bread oven {OVNOOB}Ingredients: 40 pounds whole grain flour30 cakes #6 yeast1 pound sugar3 gallons whole milk5 pounds #3 vegetable shortening0.5 pound saltDirections Run flour through sifter. Transfer to mixer, crumble in yeast, stir in the sugar and To help plan plant operations and materials purchasing, you wouldlike to transfer this kind of information to a relational database. Each Introductory Relational Database Design for Business, with Microsoft Access recipe makes one product, but there may be several different recipes forthe same product, making different quantities, using different proce-dures, or requiring slightly different ingredients. Each ingredient isalways measured in the same units; for example, sugar is always meas—ured in pounds. You need to keep track of how much of each ingredientis in each recipe, and what pieces of equipment each recipe uses. Draw an ER diagram, and write a database design outline for a data—base to store the recipe—related information. Assume that “directions”can be stored in a single “Long Text” or “Memo” field.
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question