please answer each part of the question

Assume the following functional dependencies: Bee ID Bee Name Bee ID > Hive ID (Bee resides in hive) Hive ID Hive Capacity Hive ID > Hive Phone Number Flower ID -> Flower Type Flower ID -> Color Person ID -> Person Name Bee ID + Person ID > Number of Stings Bee ID + Pollination Date + Pollination Time > Flower ID Ignore any composite columns in this example. This makes the problem simpler. Assume further that a bee can sting any number of people, and that a bee can pollinate any number of flowers. Similarly, a person can be stung by any number of bees, and a flower can be pollinated by any number of bees. Is the following table normalized? Bee If not, which normal form is violated? Provide and explain the correct normalization. Is the following table normalized? Sting If not, which normal form is violated? Provide and explain the correct normalization. Develop a complete set of normalized tables for the above scenario. Explain in detail why your relations are normalized