Problem $7-1[$LO $7-5]$

$[$The following information applies to the questions displayed below.$]$

The Rubber Duck Brewing Company is a new microbrewery. Rubber Duck's brewing process converts beer raw ingredients$-$malt extract, malted grain, adjuncts $($rice or corn$),$ hops, yeast, and water$-$into brewed beer. Over time, Rubber Duck has developed a unique recipe for each of its brewed beers. The recipe describes the specific ingredients, the sequence of brewing steps, the specific equipment, and the type of employees required for each step in the brewing process for each beer. Each step in the recipe may involve multiple ingredients $($e$.$g$.,$ barley, hops, malts, and yeast$)$ and multiple pieces of equipment, but it only requires one type of employee.

Rubber Duck assigns a unique ingredient number to each ingredient so it can track the quantity on hand. It tracks its brewed beer by the beer name: pale ale, amber ale, porter, stout, lager, pilsner, and so forth. When Rubber Duck decides to brew one of its beers, a supervisor issues a "Brew Order" for that beer, specifying the quantity in gallons to be brewed. Then, the brewing process begins. Several Rubber Duck employees perform each brewing step. Rubber Duck tracks the amount of each raw ingredient actually used in each step as well the time spent by each employee on each step.

Rubber Duck tracks its brewing equipment $($e$.$g$.,$ mash tuns, whirlpools, fermenters, and conditioning tanks$)$ by equipment item number, and it also tracks which equipment is used and how long it is used in each brewing step. Each brewing step often requires more than one piece of equipment, and some pieces of equipment are used on multiple brewing steps, although many are used in only one step. For safety, Rubber Duck only allows employees to operate equipment that they are qualified to use.

When the brewing process is complete, the brewed beer is stored in large copper tanks for aging. Ales require relatively little aging $($less than $3$ weeks$),$ while lagers may require longer aging $($up to $5$ weeks$).$ The copper tanks are tracked separately from other brewing equipment. Aging of the beer is not part of the brewing process; it takes place after the brewing process. 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:

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

$2.$ Actual quantity of this ingredient used in this brew step

$3.$ Actual time for this equipment used in this brew step

$4.$ Brew order date

$5.$ Brew order number $($brew $\backslash$#$)$

$6.$ Brew quantity in gallons

$7.$ Brew step number $($brew step $\backslash$#$)$

$8.$ Brew step description

$9.$ Brewed beer description

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

$11.$ Brewed beer name

$12.$ Brewing recipe step description

$13.$ Brewing recipe step number $($recipe step $\backslash$#$)$

$14.$ Copper tank capacity in gallons

$15.$ Copper tank number $($tank $\backslash$#$)$

$16.$ Date this employee qualified to operate this equipment

$17.$ Employee name

$18.$ Employee number $($emp $\backslash$#$)$

$19.$ Employee type

$20.$ Employee type description

$21.$ Equipment item description

$22.$ Equipment item number $($equip $\backslash$#$)$

$23.$ Ingredient description

$24.$ Ingredient number $($ingred $\backslash$#$)$

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

$26.$ Number of employees of this type

$27.$ Planned aging time for this brewed beer

$28.$ Planned time for this equipment in this step

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

$30.$ Standard quantity of this ingredient used in this recipe step

$31.$ Time spent by this employee on this brew step