Problem $7-1$ Part b

Required:

b$.$ Using the attributes listed below, prepare a list of tables and fill in the missing blanks in the table below with the correct attribute.

Attributes:

Actual aging time to date for the brewed beer in this copper tank

Actual quantity of this ingredient used in this brew step

Actual time for this equipment used in this brew step

Brew order date

Brew order number $($brew #$)$

Brew quantity in gallons

Brew step number $($brew step #$)$

Brew step description

Brewed beer description

Brewed beer quantity on hand $($QOH$)$

Brewed beer name

Brewing recipe step description

Brewing recipe step number $($recipe step #$)$

Copper tank capacity in gallons

Copper tank number $($tank #$)$

Date this employee qualified to operate this equipment

Employee name

Employee number $($emp #$)$

Employee type

Employee type description

Equipment item description

Equipment item number $($equip #$)$

Ingredient description

Ingredient number $($ingred #$)$

Ingredient quantity$-$on$-$hand $($QOH$)$

Number of employees of this type

Planned aging time for this brewed beer

Planned time for this equipment in this step

Quantity of beer in this tank $($in gallons$)$

Standard quantity of this ingredient used in this recipe step

Time spent by this employee on this brew step