- Consider following relation EMP_PROJ relation (SSN,Pnumber, Hours,Ename, Pname,Plocation)
- SSN is social security number of employee which is unique
- Pnumber is project number which is unique
- Hours is number of hours employee works on project
- Ename is Employee name
- Pname is project name
- Plocation is project location. (a) Convert the above relation into 2NF. (b) List the functional dependencies.
I think that I will get the functional dependencies and relation schema for this relation