Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address)
1.it is not in 2 NF
2.it does not have composite key
3.non-key attributes course no and course max. marks are functionally dependent
4.it has more than 3 non-key attributes
Posted Date:-2021-12-09 15:27:57