Which normal form is achieved when there are no partial dependencies in a relational database?A$)$ First Normal Form $(1$NF$)$B$)$ Second Normal Form $(2$NF$)$C$)$ Third Normal Form $(3$NF$)$D$)$ Boyce$-$Codd Normal Form $($BCNF$)$