I want an example comp;ex problem on the topic of databases with a detailed explanation of how a table with anomalies and redundancy can be transformed into a relation, first in the First Normal Form $(1$NF$),$ then in the Second Normal Form $(2$NF$),$ then in the Third Normal Form $(3$NF$),$ and finally into the Boyce$-$Codd Normal Form $($BCNF$).$