Show me the steps to solve Bonus $(1\%$ of total grade$).$

In this DB$,$ we first consider that the only Entity is abalone. Define the Primary Key for that Entity.

a$.$ Find the shorthand representation of the corresponding table. Find all the functional

dependences.

b$.$ Is the table in the first NF$?$ If not, explain why not and then perform the first

normalization.

c$.$ Is the table in the second NF$?$ If not, explain why not and then perform the second

normalization.

d$.$ Is the table in the third NF$?$ If not, explain why not and then perform the third

normalization.

e$.$ Create a CSV files for each table that has been created by the normalizations.

f$.$ File submission: Name your csv files Firstname$\_$Lastname$\_$Abalone.csv$,$

Firstname$\_$Lastname$\_$Collectors.csv and Firstname$\_$Lastname$\_$Water.csv$.$

g$.$ Draw by hand an Entity$-$Relationship Diagram using the craw foot representation. Take a

picture of it$.$

I just need help for part E$.$ and G$.$