Penny loves pastries. She wanted everyone else to love pastries, too, so she started Penny's Pastries in Orange County about 3 years ago. After a shaky start, she scored a big contract with Starbucks to provide pastries to all stores in southern California. This case describes Penny's daily baking process. Penny's bakery starts preparing fresh pastries every morning about 1:00 a.m. for delivery to local stores by 5:30 a.m. The selection and quantity of pastries vary according to the day of the week as well as the time of the year.

List the tables in the following order: resources, events, agents, type images, and linking tables.

Attributes:

Actual baking time for this baking step and this oven

Baking order#

Baking order date

Baking step#

Batch#

Batch finish time

Batch start time

Employee#

Employee hours worked on this baking step

Employee name

Employee pay rate

Equipment#

Equipment description

Equipment manufacturer

Finished product#

Finished product description

Finished product number of calories

Finished product price

Finished product QOH

Ingredient#

Ingredient cost

Ingredient description

Ingredient list#

Ingredient list description

Ingredient QOH

Ingredient unit of issue

Issue#

Issue date/time

Qty of this baked product ordered by this daily baking order

Qty of this baked product prepared in this batch

Qty of this ingredient issued on this issue#

Qty of this ingredient required for this finished product

Recipe step#

Recipe step description

Standard baking time for this recipe step with this oven

Standard labor hours for this recipe step

Total labor hours for this baking step