Question

A relation R(Student, Course, Hobby) has two independent multivalued dependencies: Student ->> Course and Student ->> Hobby, with no functional dependencies holding at all. Which of the following statements about R is correct?

A R is in 4NF because multivalued dependencies do not affect normal form classification
B R violates even 1NF because of the multivalued dependencies present
C R is in 3NF but not BCNF, since BCNF specifically requires eliminating multivalued dependencies
D R violates 2NF because Course and Hobby are partially dependent on Student
E R is in BCNF but violates 4NF due to the non-trivial multivalued dependencies
Practice Next

Hey! Ask a query

🎓
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
  • 200 Questions with Detailed Solutions
  • Section-wise Coverage (GA, English, Quant & Reasoning)