PrepSnap logoPrepSnap
Pass

Question

1.
2.
3.
4.
Answer (Detailed Solution Below)

Option 1 : StudentID → StudentName / StudentID → StudentName

Advertisement

Detailed Solution

सही उत्तर StudentID → StudentName / StudentID → StudentName है।

Key Points
Helpful?
PrepSnapprepsnap.in • Part -A

Question:

Consider R(StudentID, CourseID, StudentName, Grade) with primary key (StudentID, CourseID). Which functional dependency violates 2NF? / R(StudentID, CourseID, StudentName, Grade) पर विचार करें जिसकी प्राथमिक कुंजी (StudentID, CourseID) है। कौन-सी फंक्शनल निर्भरता 2NF का उल्लंघन करती है?

1.
StudentID → StudentName / StudentID → StudentName
2.
StudentID, CourseID → Grade / StudentID, CourseID → Grade
3.
Grade → StudentID / Grade → StudentID
4.
StudentName → CourseID / StudentName → CourseID

Correct Answer: StudentID → StudentName / StudentID → StudentName

StudentName depends on only part of the composite key (a partial dependency), which 2NF forbids; Grade depends on the full key, so (b) is acceptable. / StudentName केवल संयुक्त कुंजी के एक भाग पर निर्भर है (आंशिक निर्भरता), जिसे 2NF निषिद्ध करता है; Grade पूर्ण कुंजी पर निर्भर है, अतः (b) स्वीकार्य है।

Downloaded from PrepSnap (prepsnap.in)