1.

Identify minimal sets of functional Dependencies

2.

Step-wise normalization up

to BCNF

3.

Represent

normalization result in E-R Diagram

4.

Produce DDL

statements to implement all entities and constraints

Consider the following data brewery strength city warehouse quantity beer Choice Choice Choice Old Bob Old Bob Landlord Landlord Directors Directors Wobbly Joe Sam SmithXXXXYork region Websters XX Websters XX Websters XX Websters XXX Websters XXX Taylors Taylors Fremlins Fremlins 200 100 200 300 300 200 190 400 290 90 York York York York York North West 1 North West 4 North West 8 North West 1 North West 2 Leeds North West 8 Leeds North West 3 London South East 6 London South East 4 North West 4 Whitbread O London South East null Watery Additional Notes null use are shared by breweries Wareho . Each beer is unique to the brewer Each brewer is based in a city