PrepSnap logoPrepSnap
Pass

Question

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

Option 4 : 1NF / 1NF

Advertisement

Detailed Solution

सही उत्तर 1NF / 1NF है।

Key Points
Helpful?
PrepSnapprepsnap.in • Part -A

Question:

Relation R(StudentID, CourseID, StudentName, CourseName, Instructor, Grade) has functional dependencies: StudentID → StudentName; CourseID → CourseName; CourseID → Instructor; {StudentID, CourseID} → Grade. What is the highest normal form of R? / संबंध R(StudentID, CourseID, StudentName, CourseName, Instructor, Grade) में फलनात्मक निर्भरताएँ हैं: StudentID → StudentName; CourseID → CourseName; CourseID → Instructor; {StudentID, CourseID} → Grade। R का उच्चतम प्रसामान्य रूप क्या है?

1.
2NF / 2NF
2.
3NF / 3NF
3.
BCNF / BCNF
4.
1NF / 1NF

Correct Answer: 1NF / 1NF

The candidate key is {StudentID, CourseID}. StudentID → StudentName is a partial dependency, since a proper part of the key determines a non-prime attribute; this violates 2NF, so R is only in 1NF. / कैंडिडेट की {StudentID, CourseID} है। StudentID → StudentName आंशिक निर्भरता है, क्योंकि की का उचित भाग गैर-प्राइम एट्रिब्यूट निर्धारित करता है; यह 2NF का उल्लंघन करती है, अतः R केवल 1NF में है।

Downloaded from PrepSnap (prepsnap.in)