UGC-NET | UGC NET CS 2018 July – II | Question 67

A many-to-one relationship exists between entity sets r 1 and r 2 . How will it be represented using functional depedencies if Pk(r) denotes the primary key attribute of relation r ?
(A) Pk(r1 ) → Pk(r 2)
(B) Pk(r2 ) → Pk(r 1 )
(C) Pk(r2 ) → Pk(r1 ) and Pk(r 1 ) → Pk(r 2 )
(D) Pk(r 2 ) → Pk(r1 ) or Pk(r 1 ) → Pk(r 2)


Answer: (A)

Explanation: A many to one relationship set exists between entity sets Employee and Department.
Let two relations R1(employee with pk empId)
R2(Department with pk DId)

Here, empId can uniquely identify DId but DId can not uniquely identify the empId.
Hence, pk(R1) -> pk(R2)


Quiz of this Question



My Personal Notes arrow_drop_up


Article Tags :

Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.