Restaurant Microbrewery Database An eatery that would like to specialize in locally micro - brewed beers has asked for a database to track the local

Question

76 users unlocked this solution today!

Restaurant Microbrewery Database

An eatery that would like to specialize in locally micro$-$brewed beers has asked for a database to track

the local breweries and the beers that they craft.

The database is to track the breweries, including each brewery$$s name and main location. Also needed

are the beers of the brewery including the name of the brew, the type of beer $($lager$,$ pale ale, stout,

etc.$)$ and the alcohol content, the batch number, and the date the batch was bottled. No two breweries

produce the same beer, even though they may name them the same, such as $$Oatmeal Stout$.$

They would also like to track customers and the beers they have tried. They would like to include a

rating scale of $1$ to $10,$ and the date they tasted. If a customer tastes the same beer from the same

batch, the new rating value replaces the old one, but if the customer tastes the same beer name from

the same brewery but a different batch, an additional record would be added. The customer data

needed is name and email address