This data model depicts the creation and sale of beer by BeerCo. A batch of beer is created using a number of ingredients specified in a recipe for a specific product. A recipe is comprised of multiple different ingredients, and a record is kept for each ingredient in that recipe. Batches of beer can vary in size over time, thus requiring different amounts of the ingredients. Batches are created in set time periods $-$ there is a defined begin and end date for each batch. BeerCo. only makes a single batch of a given beer at a time. To try to get the product sold, the salesperson will advertise the beer in multiple size offerings $($cans$,$ bottles, kegs, etc.$).$ The current sales price is how much BeerCo is advertising that they will sell the product for. This price can change over time.

INGREDIENT $-$ a table for storing data on the ingredients used in making beer. BeerCo gets any specific ingredient from only one supplier.

PRODUCT $-$ a table for storing data on the beer products created by BeerCo.

RECIPE $-$ a table for storing data on which ingredients a specific beer uses in brewing. BATCH $-$ a table for storing data on individual batches of beer.

SALESPERSON $-$ table for storing data on the salespeople that try to sell beer to stores. CUSTOMER $-$ table for storing data on the stores that buy and sell beer and beer storage devices. TRANSACTION $-$ table for storing data on which parties are associated with a beer sale$/$purchase either as a buyer $($becoming the new owner$)$ of the beer$/$beer storage or a seller $($the original owner$)$ of the beer$/$beer storage. A specific instance of a beer itself can only have a single transaction, but beer storage can be bought and sold by both BeerCo. and the customers. Data on the sellers $($the original owners$)$ is necessary to create the listing.

INGREDIENT

IngredientID $-$ the identification number assigned to an ingredient instance $($i$.$e$.$ ID$1$ could be for Hops, dry category, pounds, ID$2$ could be Hops, dry category, ounces, ID$3$ could be Hops, perishable, liters, etc.$).$

Name $-$ the name of the ingredient.

Supplier $-$ the name of the supplier of the ingredient.

Classification $-$ the category of the ingredient $($wet$,$ dry, perishable, etc.$).$

UnitofSize $-$ some ingredients are measured by the ounce, some by the pound, some by the liter, etc.

UnitPrice $-$ the cost of purchasing one unit of the ingredient.

RECIPE

RecipeID $-$ the identification number assigned to a recipe.

IngredientID $-$ the identification number assigned to an ingredient used in this recipe.

Amount $-$ amount of the ingredient used in this recipe

$()$

BeerID $-$ the identification number assigned to a specific product.

RecipeID $-$ the identification number assigned to the recipe for this batch.

IngredientID $-$ the identification number assigned to an ingredient which the current recipe will use.

BatchBeginDate $-$ the date on which the batch of beer began brewing.

BatchEndDate $-$ the date on which the batch of beer stopped brewing.

AmountProduced $-$ the quantity of beer created by this recipe.

RecipeCost $-$ the total cost associated with brewing this batch of beer based on the ingredients.

PRODUCT

BeerID $-$ the identification number assigned to a specific product.

Name $-$ the name of the beer.

Address $-$ the address $($street$,$ city, state, and ZIP code$)$ where this beer is always brewed Size $-$ the amount of beer in a single package $($can$,$ bottle, $6-$pack, keg, etc.$).$

SPNumber $-$ the identification number assigned to the one and only salesperson responsible for selling this product.

CreatedDate $-$ the date on which the beer was first created.

OriginalSalesPrice $-$ the price that BeerCo. asked buyers to pay for the beer when it was first offered for sale.

CurrentSalesPrice $-$ the price that BeerCo. currently asks buyers to pay for the beer. While the asking price of the beer may change many times, only the original asking price and the most current asking price need to be retained by the system.

Storage? $-$ whether or not BeerCo. offers storage items for this product.

SALESPERSON

SPNumber $-$ an identification number assigned to a salesperson.

FirstName $-$ the first name of the salesperson.

LastName $-$ the surname or family name of the salesperson.

PhoneNumber $-$ the contact phone number for the salesperson that is given to customer. For most salespeople, this is a cell phone number. For other salespeople, it can be an office number. Some salespeople have both a cellphone number and office number.

TRANSACTION

TransactionDate $-$ the date and time on which the sale occurred.

TaxID $-$ the identification number assigned to the business associated with the sale.

BeerID $-$ an identification number given to the product being listed for sale.

Role $-$ an indicator of whether the customer is being entered as a "buyer" or "seller" of the product. The customer cannot have both roles in the same transaction.

TRANSACTION

TransactionDate $-$ the date and time on which the sale occurred.

TaxID $-$ the identification number

Identify the highest bormal form for each entity