normalize the database shown in ER diagram below (Figure1) up to at least 3NF, Hand In, A complete set of functional dependencies identified Deasect offeced Date RangeDeasect rameDeaacct DeacciptionDeaaect CodeReataucant Region NameDeasect Pcice AmountReataucasnt IdentifiecDessertMÓfferDcink NameDeasect Categocy NameIopping NameReataucant OwAecl NameRestaurantReataucasnt Ownec2 Name1Reataucant Ownec3 NameReataucant Region CodeContainReataucant daximum Capacity MumbeeNProcessMEill_IDGenerateBillEill Date and IimeCcanuity AumountEooth Iype IextEill_AumountBoothContainNBooth Iype CodeSmoking section IndicatocEooth Location CodeEooth Capacity mysql select * from Restaurant;RESTAURANT_IDRESTAURANT_OWNER1_NAME RESTAURANT_OWNER2_NAMERESTAURANT_OWNER3_NAMERESTAURANT_REGION_CODE | RESTAURANT_REGION_NAME | RESTAURANT_MAX_CAPACITY || Paul SmithMary DoeBob Jones123Bob JonesNENortheast50 || Bill BarkerMary DoeMary Doe| Mary DoeMary DoeMary Doe124James PierceNENortheast200SWSW| SW125NULLNULLSouthwest175100 |322 |Mike Myers| Mike MyersMike Myers| Mike Myers126NULLSouthwest326| NULLSouthwest454NULLNENortheast145789NULL| NENortheast678|mysql select * from Dessert;DESSERT_CODE | DESSERT_0FFERED_DATE_RANGE | DESSERT_NAME| DESSERT_DESCR| DESSERT_CATEGORY_CODEDRINK_NAME| TOPPNING_NAME | DESSERT_PRICE_AMOUNT| AB| 1999-10-1| Scary Sundae| Lots of licorice, bats, and hot fudge Holiday, Cookie, MediumSpooky Hot Chocolate | Hot fudge1999-10-312.95over broomshaped cookiesВС| 1996-1-1 - 2002-12-31| Banana Split| Three large scoops of ice cream with|Fruit, Frozen, Large| NULL| Hot fudge4.95| two fresh bananas and an unbelievablenumber of toppings, including hot fudge|and strawberry| 2001-6-1 - 2001-9-1|| Cherries|SmallЕЕ| Summer Refresher | Lots of different types of fruits,|Fruit, Health, Seasonal, |NULL1.95|all put into a blendermysql select * from Bill;| BILL ID | BOOTHCODE | DESSERT CODE | DESSERT OFFERED DATE RANGE | RESTAURANT ID | BILL DATE AND TIMEBILL_AMOUNT | GRATUITY_AMOUNT |ВОOTH ABВОOTH AEВООTH ABВООTH ADВОOTH BC320 |20 |0.5 |30 |20АВ1999-10-1 - 1999-10-314541999-10-12 20:34:59|EE| AB| BC| AB272001-6-1 - 2001-9-17892000-10-21 15:30:12400.5291999-10-1 - 1999-10-31| 4541999-10-12 12:34:00330771996-1-1 - 2002-12-317892000-10-15 20:15:191500.99801999-10-1 - 1999-10-31| 4541999-10-10 22:25:09310.510.5|mysql select * from Offer;| DESSERT CODE | DESSERT OFFERED DATE RANGERESTAURANT ID |АВ1999-10-1 - 1999-10-31454| 789| 789BC1996-1-12002-12-31ЕЕ2001-6-1 - 2001-9-1mysql select * from Booth;ВООTHCODERESTAURANT_ID | SMOKE_SECTION_INDICATOR | BOOTH_CAPACITY | BOOTHTYP_CODE | BOOTHTYP_TEXT |ВООTH ABВООTH ADВООTH AEВООTH BC4 T2| T8 | T6 | E| Table| Table| Table| Bench123Y125N124Y123Y

Question

normalize the database shown in ER diagram below (Figure1) up to at least 3NF, Hand In, A complete set of functional dependencies identified Deasect offeced Date RangeDeasect rameDeaacct DeacciptionDeaaect CodeReataucant Region NameDeasect Pcice AmountReataucasnt IdentifiecDessertMÓfferDcink NameDeasect Categocy NameIopping NameReataucant OwAecl NameRestaurantReataucasnt Ownec2 Name1Reataucant Ownec3 NameReataucant Region CodeContainReataucant daximum Capacity MumbeeNProcessMEill_IDGenerateBillEill Date and IimeCcanuity AumountEooth Iype IextEill_AumountBoothContainNBooth Iype CodeSmoking section IndicatocEooth Location CodeEooth Capacity mysql> select * from Restaurant;RESTAURANT_IDRESTAURANT_OWNER1_NAME RESTAURANT_OWNER2_NAMERESTAURANT_OWNER3_NAMERESTAURANT_REGION_CODE | RESTAURANT_REGION_NAME | RESTAURANT_MAX_CAPACITY || Paul SmithMary DoeBob Jones123Bob JonesNENortheast50 || Bill BarkerMary DoeMary Doe| Mary DoeMary DoeMary Doe124James PierceNENortheast200SWSW| SW125NULLNULLSouthwest175100 |322 |Mike Myers| Mike MyersMike Myers| Mike Myers126NULLSouthwest326| NULLSouthwest454NULLNENortheast145789NULL| NENortheast678|mysql> select * from Dessert;DESSERT_CODE | DESSERT_0FFERED_DATE_RANGE | DESSERT_NAME| DESSERT_DESCR| DESSERT_CATEGORY_CODEDRINK_NAME| TOPPNING_NAME | DESSERT_PRICE_AMOUNT| AB| 1999-10-1| Scary Sundae| Lots of licorice, bats, and hot fudge Holiday, Cookie, MediumSpooky Hot Chocolate | Hot fudge1999-10-312.95over broomshaped cookiesВС| 1996-1-1 - 2002-12-31| Banana Split| Three large scoops of ice cream with|Fruit, Frozen, Large| NULL| Hot fudge4.95| two fresh bananas and an unbelievablenumber of toppings, including hot fudge|and strawberry| 2001-6-1 - 2001-9-1|| Cherries|SmallЕЕ| Summer Refresher | Lots of different types of fruits,|Fruit, Health, Seasonal, |NULL1.95|all put into a blendermysql> select * from Bill;| BILL ID | BOOTHCODE | DESSERT CODE | DESSERT OFFERED DATE RANGE | RESTAURANT ID | BILL DATE AND TIMEBILL_AMOUNT | GRATUITY_AMOUNT |ВОOTH ABВОOTH AEВООTH ABВООTH ADВОOTH BC320 |20 |0.5 |30 |20АВ1999-10-1 - 1999-10-314541999-10-12 20:34:59|EE| AB| BC| AB272001-6-1 - 2001-9-17892000-10-21 15:30:12400.5291999-10-1 - 1999-10-31| 4541999-10-12 12:34:00330771996-1-1 - 2002-12-317892000-10-15 20:15:191500.99801999-10-1 - 1999-10-31| 4541999-10-10 22:25:09310.510.5|mysql> select * from Offer;| DESSERT CODE | DESSERT OFFERED DATE RANGERESTAURANT ID |АВ1999-10-1 - 1999-10-31454| 789| 789BC1996-1-12002-12-31ЕЕ2001-6-1 - 2001-9-1mysql> select * from Booth;ВООTHCODERESTAURANT_ID | SMOKE_SECTION_INDICATOR | BOOTH_CAPACITY | BOOTHTYP_CODE | BOOTHTYP_TEXT |ВООTH ABВООTH ADВООTH AEВООTH BC4 T2| T8 | T6 | E| Table| Table| Table| Bench123Y125N124Y123Y

Accepted Answer

Each entity is described through a set of attributes (e.G., Employee = (Name, Address, Birthdate…