Problem 6 (12 points): Identify the single valued Primary Keys in the Employee table if we know the table will never change. Use the table attached at the end of the assignment. Dno Figure 5.6 One possible database state for the COMPANY relational database schema, EMPLOYEE Frame Minit Lname Ssn Bdate Address Sex Salary Super_ss John B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 Alicia Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 Jennifer S Wallace 9876543211941-06-20 291 Berry, Bellaire, TX F 43000 B88655555 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 Joyce English 453453453 1972-07-31 5631 Rice, Houston, TX 25000 333445555 Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 James E Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NUL 5 5 4 5 DEPARTMENT 1 Dname Dnumber 5 Research Administration Headquarters Mgr_ssn 333445555 987654321 888665555 4 Mgr_start_cate 1988-05-22 1995-01-01 1981-06-19 1 DEPT_LOCATIONS Dnumber Dlocation 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston WORKS ON Essn Pno Hours 123456789 123456789 1 32.5 Pnumber Dnum 2 7.5 1 5 3 40.0 PROJECT Prame ProductX ProductY Productz Computerization Reorganization Newbenefits 2 666584444 453453453 453453453 333445555 5 1 20.0 3 Plocation Beliaire Sugarland Houston Stafford Houston Stafford 5 2 20.0 10 4 2 10.0 20 1 3 10.0 30 4 333445555 333445555 333445555 10 10.0 DEPENDENT 20 10.0 Essn Dependent_name 30 30.0 Sex Bdate 999887777 999887777 987987987 10 10.0 333445555 333445555 Alice Theodore F 10 35.0 M 30 1986-04-05 1983-10-25 1958-05-03 1942-02-28 987987987 987654321 5.0 F Joy Abner 30 20.0 M Relationship Daughter Son Spouse Spouse Son Daughter Spouse 333445555 987654321 123456789 123456789 123456789 - 987654321 Michael 20 15.0 M 888665555 Alice 1988-01-04 1988-12-30 20 F NULL Elizabeth F 1967-05-05