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.

  1. A.

    First Normal Form (1NF)

  2. B.

    Second Normal Form (2NF)

  3. C.

    Third Normal Form (3NF)

  4. D.

    Boyce-Codd Normal Form (BCNF)

  5. E.

    Fourth Normal Form (4NF)

Attempted by 361 students.

Sign up free to check your answer

Sign up free

Explore the full course: Ibps So It Mains

Loading lesson…