1.

Given the following relation Student (roll no, name, course no, course max. marks, year of study, address) The corresponding 3 NF relations are

A. student (roll no, name, year of study, address) course (course no, course max. marks)
B. student ( roll no, name, year of study, address) student (roll no, course no) course (course no, course max. marks)
C. student (roll no , name, address) year (roll no, year of study) course (course no, course max. marks)
D. student (roll no, name, address) course (course no, course max. marks, year of study)
Answer» C. student (roll no , name, address) year (roll no, year of study) course (course no, course max. marks)


Discussion

No Comment Found