Consider the tables below. Using the normal forms seen in class, make these tables BCNF \begin{tabular}{|l|l|l|l|} \hline DERARTIIINT \\ \hline Pname & Dnumber & Dmerssin & Rlacations \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline DBRARTMIBNT & & & \\ \hline Dname & Dnumber & Dmgrssn & Plocations \\ \hline Research & 5 & 333445555 & Bellaire,Sugarland,Houston \\ \hline Administration & 4 & 987654321 & \{Stafford \\ \hline Headquarters & 1 & 88866555 & \{Houston \\ \hline \end{tabular} WORKS_ON \begin{tabular}{|l|l|l|l|} \hline Ssn & Ename & Pnumber & Hours \\ \hline 123456789 & Smith, John B. & 1 & 32.5 \\ & 2 & 7.5 \\ \hline 666884444 & Narayan, Rarnesh K. & 3 & 40.0 \\ \hline 453453543 & English, Joyce A. & 1 & 20.0 \\ & & 2 & 20.0 \\ \hline & & 2 & 10.0 \\ & Wong, Franklin T. & 3 & 10.0 \\ & & 10 & 10.0 \\ & & 20 & 10.0 \\ \hline 933445555 & Zalaya, Alicia J. & 30 & 30.0 \\ & 10 & 10.0 \\ \hline 987987987 & Jabbar, Ahmad V. & 30 & 35.0 \\ & 10 & 5.0 \\ \hline 887654321 & Wallace, Jennifer S. & 30 & 20.0 \\ & 20 & 15.0 \\ \hline \end{tabular} Exercise 1: Consider the tables below. Using the normal forms seen in class, make these tables BCNF WORKS_ON \begin{tabular}{|l|l|l|l|} \hline Sen & Ename & Poumber & Hours \\ \hline 123456789 & Smith, John B. & 1 & 32.5 \\ \hline 666884444 & 2 & 7.5 \\ \hline 453453543 & Narayan, Ramesh K. & 3 & 40.0 \\ \hline & English, Joyce A. & 1 & 20.0 \\ & & 2 & 20.0 \\ \hline & & 2 & 10.0 \\ & Wong, Franklin T. & 3 & 10.0 \\ & & 10.0 \\ & & 10 & 10.0 \\ \hline 9998877777 & Zalaya, Alicia J. & 30 & 30.0 \\ & 987987987 & 10 & 10.0 \\ \hline 987654321 & Jabbar, Ahmad V. & 30 & 35.0 \\ \hline 888665555 & 10 & 5.0 \\ \hline & Wallace, Jennifer S. & 30 & 20.0 \\ & Borg, James E. & 20 & 15.0 \\ \hline & & & NULL \\ \hline \end{tabular}