Question: What normal form is this relation in based on the following dependencies Full Dependency ( Primary Key ) table [ [ EmpID , EmpName,CubicleNo,DeptID,DeptName

What normal form is this relation in based on the following dependencies
Full Dependency (Primary Key)
\table[[EmpID,EmpName,CubicleNo,DeptID,DeptName],[E0001,Janet Wilson,A-234,100,Accounting],[E0003,Judy Lee,A-234,200,Sales],[E0039,Tom Castello,A-123,300,Operations],[E0045,Zee Hank,B-322,100,Accounting],[E0234,Helen Miles,B-322,200,Sales]]
Transitive Dependency
3NF
4NF
1NF
2NF
 What normal form is this relation in based on the following

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 Databases Questions!