Normalise this table to the second normal form (2NF). (Please use appropriate schema/table names) SSN = Social Security Number. PNUMBER = Project Number. HOURS = Hours spent on a project per week. ENAME = Employees name. PNAME = Project name. PLOCATION = Product location.

SSN PNUMBER HOURS ENAME PNAME PLOCATION 12346789 1 32 Smith, John B Product X Bellaire 123456789 2 7 Smith, John B Product Y Sugarland 666884444 3 40 Narayan, Ramesh K Product Z Houston 453453453 1 20 English,Joyce A Product X Bellaire 453453453 2 20 English,Joyce A Product Y Sugarland 333445555 2 10 Wong, Franklin T Product Y Sugarland 333445555 3 10 Wong, Franklin T Product Z Houston 333445555 10 10 Wong, Franklin T Computerization Stafford 333445555 20 10 Wong, Franklin T Reorganization Houston 999887777 30 30 Zelaya,Alicia J New Benefits Stafford 999887777 10 10 Zelaya,Alicia J Computerization Stafford 987987987 10 35 Wallace, Jennifer S Computerization Stafford 987987987 30 5 Wallace, Jennifer S New Benefits Stafford