Normalization Report Data Model

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 create the listing.