Question: Apply first normal form and second normal form. This is a database problem for a debt collector company. We have the normalized version tables for


Apply first normal form and second normal form.
This is a database problem for a debt collector company. We have the normalized version tables for all the attributes; now we've been asked to apply 1NF and 2NF for them.
3rd Normalization \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline debtorID & employeeID & productCode & debtorName & debtorMobile & debtorAddress & debtorAge & debtorGender & totalDebt \\ \hline & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|} \hline teamLeaderID & teamID & teamLeaderID & teamLeaderName & teamLeaderMobile & teamLeaderEmail & teamLeaderAddress \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline teamID & deptID & teamLeaderID \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline paymentID & debtorID & paidAmount & statusCode & paidDate & debtBalance \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \cline { 2 - 3 } statusCode & statusDescription & debtorID \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline productCode & productDescription & teamID \\ \hline & & \\ \hline & & \\ \hline \end{tabular} 3rd Normalization \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline debtorID & employeeID & productCode & debtorName & debtorMobile & debtorAddress & debtorAge & debtorGender & totalDebt \\ \hline & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|} \hline teamLeaderID & teamID & teamLeaderID & teamLeaderName & teamLeaderMobile & teamLeaderEmail & teamLeaderAddress \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline teamID & deptID & teamLeaderID \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline paymentID & debtorID & paidAmount & statusCode & paidDate & debtBalance \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \cline { 2 - 3 } statusCode & statusDescription & debtorID \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline productCode & productDescription & teamID \\ \hline & & \\ \hline & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
