Question: Exercise 3 * * * The following relation is in a ) UNF b ) 1 N F c ) 2 N F d )
Exercise
The following relation is in
a UNF
b
c
d
tableStudentIDName,DepartmentID,DepartmentKate Smith,DComputer ScienceJane Wright,DHistoryRobert Miller,DChemistry
Why is this a NF table? StudentID define name, and departmentID define department, isn't this partial dependency? shouldnt it be NF Please explain
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
