[4] Please find all the candidate keys.

[5] Choose a primary key for above table.

[6] Find all the functional dependencies. And identify the dependency type (i.e. primary key, partial, or transitive)

(Employee Project Department table) DNAME Research Research Researchh Research SSN FNAME LNAME PN DNUMBER 333445555FranklinWong 333445555FranklinWong 333445555Franklin Wong 333445555 FranklinWong 987654321 JenniferWallace 987654321 JenniferWallace 888665555 James 10 20 30 20 20 Pnamne ProductY Product Z Computerization Reorganizatiorn New Benefits Administration Reorganization Administration ReorganizationHeadquarters 4 4 Borg