Given the following relation Student (roll no , name, course no, course max.…

PYQ RPSC Programmer 2011

Given the following relation

Student (roll no , name, course no, course max. marks, year of study, address)

The corresponding 3 NF relations are

  1. A.

    student (roll no , name, year of study, address) course (course no , course max. marks) Proj_stud (project, student no.)

  2. B.

    student (roll no, name, year of study, address) student (roll no , course no ) course (course no , course max. marks)

  3. C.

    student (roll no , name, address) year (roll no , year of study) course (course no , course max. marks)

  4. D.

    student (roll no , name, address) course (course no , course max. marks, year of study)

Sign up free to check your answer

Sign up free

Explore the full course: Rpsc Programmer

Loading lesson…