$\backslash$table$[[$ESSN$,$Pno,Query$1,$Plocation$],[$ours$,$SSN$,$fN$,$IName,r$,$Pname$],[23456789,1,32\mathrm{.}5,123456789,$John,Smith,,ProductX,Bellaire$],[23456789,2,7\mathrm{.}5,123456789,$John,Smith,,ProductY,Sugarland$],[66884444,3,40,666884444,$Ramesh,Narayan,,ProductZ,Houston$],[53453453,1|,20,453453,$Joyce,English,,Prod,Bellaire$],[53453453,2,20,4534,$Joyce,English,,Pro,Sug$],[33445555,2,10,33344,$Franklin,Wong,,Pro,Sugarland$],[333445555,3,10,3334,$Franklin,Wong,,Pro,Houston$],[33445555,10,10,3334,$Franklin,,,Cor,Sta$],[333445555,20,10,3334,$Franklin,Wong,,Reorganization,Houston$],[99887777,30,30,999887777,$Alicia,Zelaya,,nefits,Stafford$],[99887777,10,10,9998,$Alicia,Zelaya,,rization,Stafford$],[87987987,10,35,98798,$Ahmad,Jabbar,,erization,Stafford$],[987987987,30,,987987987,$Ahmad,Jabbar,,Newb,Stafford$],[87654321,30,20,987654321,$Jennifer,Wallace,,Newbenefits,Stafford$],[987654321,20,15,987654321,$Jennifer,Wallace,,Reorganization,Houston$],[888665555,20,,888665555,$James,Borg,,Reorganization,Houston$]]$

$[2\mathrm{.}1]$ Please find out all the candidate keys and then choose the primary key. $($The primary key could be a composite key$)$

$[2\mathrm{.}2]$ Please find all the functional dependencies.

fd$1$:

fd$2$:

fd$3$:

fd$4$:

$[2\mathrm{.}3]$ Please find out the second normal form $($in the format of relational schema$).$

$[2\mathrm{.}4]$ Please find out the third normal form.