Question: Exercise 3 * * * The following relation is in a ) UNF b ) 1 N F c ) 2 N F d )

Exercise 3
*** The following relation is in
a) UNF
b)1NF
c)2NF
d)3NF
\table[[StudentID,Name,DepartmentID,Department],[0001,Kate Smith,D1,Computer Science],[0002,Jane Wright,D3,History],[0003,Robert Miller,D6,Chemistry]]
Why is this a 2NF table? StudentID define name, and departmentID define department, isn't this partial dependency? shouldnt it be 1NF? Please explain
Exercise 3 * * * The following relation is in a )

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!