In a relation Student_Exam(roll_no, course_code, marks, grade, passing_marks), the primary key is (roll_no, course_code). Suppose marks determines grade (marks -> grade), where neither is a candidate key. What type of dependency does this represent, and which normal form is violated?
- APartial dependency; violates 1NF
- BMulti-valued dependency; violates 2NF
- CTrivial dependency; violates BCNF
- DTransitive dependency; violates 3NF