Question: table [ [ Resources ] , [ Beer ingredients, [ , ( PK ) , ingredient description, ingredient quantify - on - hand [

\table[[Resources],[Beer ingredients,[,(PK), ingredient description, ingredient quantify-on-hand [QOH]],[Brewed beer,Brewed beer name (PK),,5,, Brewed beer quantity on hand, Planned aging tim],[\table[[Brewing],[equipment]],,, Equipment item description]],[Copper tanks,\table[[Copper tank number [tank #](PK), Copper tank capacity in gallons [gals], actual aging time, quantity of beer in this tank,],[(FK)]],],[Events],[Brew steps,Brew step number (PK), brew step description, recipe step # (FK),,(FK)],[Brew order,\table[[Brew order number (brew ord #)(PK), brew order date,],[beer name (FK)]],,,[supervisor] emp # (FK), brew],[Agents],[Employee,Employee number [emp#](PK),,P,, employee type (FK)]]
 \table[[Resources],[Beer ingredients,[,(PK), ingredient description, ingredient quantify-on-hand [QOH]],[Brewed beer,Brewed beer name (PK),,5,,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!