Teaching UGC NET Mock Test Series 2025 (Paper 1 & 2) DBMS Integrity Constraints and Normal Form Functional Dependency
A many-to-one relationship exists between entity sets r1 and r2. How will it be represented using functional dependencies if Pk(r) denotes the primary key attribute of relation r?
1
Pk(r1) → Pk(r2)
2
Pk(r2) → Pk(r1)
3
Pk(r2) → Pk(r1) and Pk(r1) → Pk(r2)
4
Pk(r2) → Pk(r1) or Pk(r1) → Pk(r2)