Instructions: Read the case study twice and then solve.Abbreviations: BR$=$Branch, C$=$Country, E$-$Employee, T$=$ Toy, M$=$Manufacturer, M$-$C$=$Manufacturer CountryKHILONAY$-$Toyshop is an international chain of toyshop for kids. It wants to keep database of its BRANCHes in different COUNTRIES $($BR$-$ID$,$ BR$-$ADDRESS, C$-$ID$,$ C$-$NAME$),$ each branch can have $5$ or more Employees $($E$-$ID$,$ E$-$NAME, E$-$DESIG, E$-$SALARY, E$-$EMAIL$)$ while an employee can belong to only one Branch. A Branch can keep no or many TOYS manufactured by different manufacturers of different countries of world $($T$-$ID$,$ T$-$NAME, T$-$PRICE, M$-$ID$,$ M$-$NAME, M$-$C$-$ID$,$ M$-$C$-$NAME$).$ While One Toy can be kept by one or many Branches. The Toys can ONLY be one of two types MANUAL$-$TOYS $($MACHINE TYPE$)$ and ELECTRICAL$-$TOYS $($WATTS$,$ VOLTAGE$).$One or more BATTERY $($BATTERY$-$ID$,$ VOLT, COMPANY, TYPE$)$ can be provided with one Electrical$-$Toy. While One Battery can be provided with one or many Electrical Toys. One Toy can have no or many SALES$-$HISTROY $($Date$,$ Quantity, Total Amount$)$ While One sales$-$history belongs to only one toy. And if there is no toy then there is no Sales$-$History.a$)$ Draw an Enhanced Entity Relational Ship Diagram $($EERD$)$ Keeping in view only the points mentioned in above given paragraph.$(8)$b$)$ Represent Entity Classes and Relationships.$(5)$c$)$ Put some record ONLY in BRANCH and TOY and discuss anomalies $($each one in one sentence only$).$ Then Normalize the same two table upto $3$ NF by considering the following points:$(7)($i$)$ One Branch can be only in One Country. One Country can have many Branches. We want to keep the data of a country even if there is no branch of Khilonay toyshop in that country. $($ii$)$ One Toy can be manufactured by Only One Manufacturer. One Manufacturer can manufacture many toys. One Manufacturer can be in many Countries while a country can have many manufacturers.