Question: E _ P ( SSN , PNUMBER, HOURS, ENAME, PNAME, PLOCATION ) ( 2 ) The functional dependencies are: FD 1 : { SSN ,

E_P(SSN, PNUMBER, HOURS, ENAME, PNAME, PLOCATION)(2)
The functional dependencies are:
FD1: {SSN, PNUMBER}->{HOURS}
FD2: {SSN}->{ENAME}
FD3: {PNUMBER}->{PNAME, PLOCATION}
A.(2 points) Is it in 3NF (3rd Normal Form)?
B.(2 points) If not, in what form is it (non-1NF,1NF, or 2NF)?
C.(12 points) If it is not in 3NF, then normalize it to 3NF.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!