Consider the relation: R(Roll_No, Student_ID, Course_ID) with the following…
PYQ IBPS SO CRP SPL-XIV (2024)Modified — slightly modified from the official paper; see the solution
Consider the relation: R(Roll_No, Student_ID, Course_ID) with the following functional dependencies:
{Roll_No, Course_ID} → {Student_ID}
{Student_ID, Course_ID} → {Roll_No}
Student_ID → Roll_No
The above dependencies completely describe all functional dependencies of the relation. Identify the highest normal form satisfied by the relation.
- A.
First Normal Form (1NF)
- B.
Second Normal Form (2NF)
- C.
Third Normal Form (3NF)
- D.
Boyce-Codd Normal Form (BCNF)
- E.
Fourth Normal Form (4NF)
Attempted by 361 students.
Sign up free to check your answer
Sign up freeLoading lesson…

