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. Overtime, the Rubber Duck has developed a unique recipe for each of its brewed beers. the receipe 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 receipe may invlove multiple ingredients(e.g. barley, hops, malts, and yeast) and multiple pieces of equipement, but it only requires one type of employee.

Rubber duck assigns a unique ingredient number to each ingredient so it can track the quanitity on hand. It tracks its brewed beer by the beer name:pale ale,amber ale, porter,stout, lager, pilsner, and so on. when rubber duck decides to brew one if its beers a supervisor issues a "Brew Order" for that beer, specifying the quanitity in gallons to be brewed.Then, the brewing process begins. Several Rubber Ducks employees perform each brewing step. Rubber Duck tracks teh 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 equipement (mash tuns, whirlpools, fementers, and conditioning tanks) by quipment item number, and it also tracks which equipemnt 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, altough many are used in only one step. For safety, rubber duck only allows employees to operate equipement that they are quilified to use.

When the brewing process is complete, the brewed beer is stored in large copper tanks for aging. Ales require relativley little aging (less than 3 weeks ) while lagers may require longer aging (up to 5 weeks). The copper tanks are tracked seperately from other brewing equipement. Aging of the beer is not part of the brewing process; it takes place after the brewing process.

a.) Prepare a UML class diagram that captures Rubber ducks's brewing process.

b.) using the preceding infomation and the following attributes list, prepare a lisiting of the relational tables , indicating the primary keys (PK) and foreign keys (FK) for each table.

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 equipement used in this brew step

Brew order date

Brew order number

Brew quantity in gallons

Brew Step number

Brew step description

Brew beer quantity on hand

brewed beer name

brewing receipe step description

Brewing recipe step number

Copper tank number

Copper tank Capacity

date this employee quialified to operate this equipement

employee name

employee #

employee type

employee type descrip

equipemnt item description

equipment item number

ingredient descrip

ingredient number

ingredient quanity on hand

number of employees of this type

planned aging time for this brewd beer

planned time for this equipment in this step

quanitity of beer in this tank

standard quanitty of this ingredient used in this receipe step

time spent by this employee on this brew step